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

TransferText Maintains Old Format

P: n/a
Using Access-2k

The code below is used to generate a csv file that is used by another
application. All works fine till I add an additional field to the query. The
existing codes generates a file with the same field prior to the modification.
The only way around this is to rename the "FileName", then all fields are
included.

I've tried to live with this undocumented feature, but now it's time to seek a
solution.

Any suggestions appreciated.

******************************************
'Export query as delimited file
DoCmd.TransferText TransferType:=acExportDelim, _
TableName:="qryMyFileOut", _
FileName:="\\MyServer\MyDir\MyFileNew.csv", _
Hasfieldnames:=True 'w/Headers

Thanks in advance

"And.... Exactly at which point did you consider this a good idea?"
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.