Export table into csv file: enclosed in double quotes

Abhishek Bhatt

Need to export table into csv file. Tried following:

DoCmd.TransferText acExportDelim, "", TABLENAME, "C:\abc.csv", False, ""

But the exported file contains data enclosed in double quotes i.e. if data in table is 123, it's coming in exported file as "123".

Is there any setting to avoid this?

Nov 1 '07 #1

nico5038

Did you try to export the file first manually and to store the exportdefinition (With the [Advanced] button. When you have the correct format, you can use this specification in the DoCmd statement.

Nic;o)

Nov 2 '07 #2