Problems exporting to txt file

[Jamesc]

Hi

I have a table with 1 field in that I want to export to a txt file. I am using the transfertext method, the text files are created but there is nothing in them.

The table looks like this:

CommandHeader
;No data
;
;++++++++++++++++++++++++++++++++++++
;+ copyright blurb +
;++++++++++++++++++++++++++++++++++++

"CommandHeader" being the field name

The line in VBA is

DoCmd.TransferText acExportDelim, "TempHeader Export Specification", "HeaderFileCreate", Location & "\" & Period & ".txt", False, ""

Thanks

 

[MyBoo]

Is "HeaderFileCreate" the table you are trying to export from?

Example
The following example exports the data from the Microsoft Access table External Report to the delimited text file April.doc by using the specification Standard Output:

DoCmd.TransferText acExportDelim, "Standard Output", "External Report", "C:\Txtfiles\April.doc"