[AccessD] Exporting Using Code

Hi Paul

> I tried reversing the process, i.e bringing the text file into the table but said I can't define field more than once, I think it's because there are no field names in the text file.  Is there a
> way of saying there are no field names in the text file ?

Reversing? Reverse what?
But this type of query is a one-shot. The text file must not exist.

/gustav


> 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