Export to CSV File with table headers (1 Viewer)

tbasher · Aug 10, 2004

Currently I am using the following code to export to a .csv file, however, the table headers do not come across:
DoCmd.TransferText acExportDelim, , "QueryName", "test.csv"

I can use the following code to export into a .xls file and the table headers come across. The only problem is that I need a .csv and to do that I must open up excel then save as a .csv:
DoCmd.OutputTo acOutputTable, "queryname", acFormatXLS, "test.xls", 0

Is there any way to expot to a .csv file with the table headers?

Thanks!

KenHigg · Aug 10, 2004

Did you try acFormatTXT?

ken

tbasher · Aug 11, 2004

Thanks Ken for the response. I tried the acFormattxt and it gave me a type mismatch error when I ran the command. Any more ideas?

KenHigg · Aug 11, 2004

The export wizard has has checkbox to 'Include field names on first row'.

Shouldn't this work?

ken

KenHigg · Aug 11, 2004

Sorry, You were trying to automate this...

Seems there is a 'HasFieldNames' switch in the trf text function...

???
ken

benti · Aug 13, 2004

Use the folloing sentence:

DoCmd.TransferText acExportDelim, , "QueryName", "test.csv", True

tbasher · Aug 13, 2004

Adding 'True' worked. Thanks for the Help!

colonel66 · Oct 8, 2016

just joined the forum and i was looking for a way to export a query to a csv file and this thread has been a great help!

the export goes to my Documents folder - which is not a train smash - but is there no way in specifying a specific file path instead.

for instance when creating a pdf of the report, the PDF file is saved in a corresponding month end folder within a designated client folder.

With the CSV going to the Documents folder, i will have to manually move to the client folder.

battles · Oct 19, 2017

For some reason this isn't working for me, my code says:

Code:

DoCmd.TransferText acExportDelim, "MyTabDelimExport", "MyQueryName", "C:\MyFileName.TXT", True

And it exports without the headers

Export to CSV File with table headers (1 Viewer)

tbasher

Registered User.

KenHigg

Registered User

tbasher

Registered User.

KenHigg

Registered User

KenHigg

Registered User

benti

New member

tbasher

Registered User.

colonel66

New member

battles

New member

Similar threads

Users who are viewing this thread