Export Access Table to "|" delimited text file

[Stella]

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!!!

[wlc04]

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.