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

Export Data into textfile

P: n/a
Hi:
Can any one please tell me how to i export data thru VBA code as same
when i right click on any table and then it ask me to export data as
comma delimited. Can i do the same thru VBA code. I need it not prompt
me for comma delimited or fixed length as i only need the comma
delimited text. It automatically convert the table into comma delimited
text.

Thanks.

Nov 11 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

co*********@gmail.com wrote:
Hi:
Can any one please tell me how to i export data thru VBA code as same
when i right click on any table and then it ask me to export data as
comma delimited. Can i do the same thru VBA code. I need it not prompt
me for comma delimited or fixed length as i only need the comma
delimited text. It automatically convert the table into comma delimited
text.

Thanks.
TransferText you mean? It's in the Help file. And you can build
macros to do it all for you.

Nov 11 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.