Exporting csv file but headers not created

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TGW - 30 May 2007 11:25 GMT

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

Reply to this Message

Jerry Whittle - 30 May 2007 17:04 GMT

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"?

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> Hi there,
>
[quoted text clipped - 11 lines]
>
> Cheers

Reply to this Message