By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,740 Members | 844 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,740 IT Pros & Developers. It's quick & easy.

Export table into csv file: enclosed in double quotes

P: 36
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
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,072
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.

Nov 2 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.