Exporting csv file but headers not created

[Guest]

Hi there,

Am trying to export query to a CSV file with header details to a specific
location.

Nearly have it working in that the file is created and stored where I expect
it to be, except tthe file headers are not created even though I appear to
indicate I wish them to be as per the code below.

DoCmd.TransferText acExportDelim, "SAP_EXTRACT", "qry_create_journal",
strDirectory & "\IA_RBC_Journal.CSV", True

Am working in Access 2000. Any ideas or suggestions?

Cheers

 

[Guest]

Very strange as it works for me using the same code in A03. Some WAGs:

Change True to -1. Probably didn't help but worth a try.

Hard code in the file path and see what happens.

Remove the export specification and see if that helps.

Last thought: By "file headers" am I correct in thinking that you meant
"field headers"?