[AccessD] Exporting Using Code

Hi paul

The general syntax is like:

  SELECT
    *
  INTO
    [Text;Database=C:\Windows\Temp].[TestDate.txt]
  FROM
    tblExportFrom;

/gustav


> I have the following code to export a query into an excel sheet:
> strSQL = "SELECT * INTO " & _
>   "[Excel 8.0; Database=C:\Email\ProgrammeSummary.xls].” &  _
>   “[ProgrammeSummary] " & _
>   "FROM qryProgrammeSummary "
>
> Does anyone know if I can use the same method to export to a text
> file, if so could someone show me the syntax to it, cause I have
> been playing around with this for the last hour, and can’t seem to
> do it.
 
> Thanks in advance for any help.
 
> Paul Hartland