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

Export Access Table to "|" delimited text file

P: 3
Help!!! Am extremely new to VBA. Want to set up code behind a button that will prompt the user for a table name(source of data) and file name(end result of export) and then export the data into a pipe delimited text file.

Appreciate any help!!!
Jun 5 '06 #1
Share this Question
Share on Google+
1 Reply

P: 70
When you export tables export specifications are created so that access knows how to handle the fields and what parameters you wish to use for delimeters, etc. How many table options do you have? You may need to create export specifications for each table. At this point there are different options to you have to for the user so they know what to choose from. Let me know how many tables you have and more specifically how you want to present this to the user and I will try to help you further.
Jun 12 '06 #2

Post your reply

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