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

TransferText to .CSV With Column Headings

P: 47
Is there a way to use transfertext to export to a tab delimited .csv file that includes column headings?

Any help will be appreciated.

Thanks,
John
Jan 8 '08 #1
Share this Question
Share on Google+
2 Replies


FishVal
Expert 2.5K+
P: 2,653
Hi, John.

As far as I know DoCmd.TransferText gives an option to include column headings in exported csv file.

Regards,
Fish
Jan 8 '08 #2

jaxjagfan
Expert 100+
P: 254
TransferText(acExportDelim, SpecificationName, TableName, FileName, -1)

The "-1" indicates to include field names.
Jan 8 '08 #3

Post your reply

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