How can I export MS ACCESS tables and queries as tab-delimited text files?

I am trying to set up a database to manipulate files and, when done, I need to export those files in a tab-delimited text format for import into another application. I found one solution posted on the exchange but I can't get it to work.
Who is Participating?
Helen FeddemaConnect With a Mentor Commented:
For queries, they should be select queries without criteria or parameters -- if you need those features, convert the query to a make-table query so you can use the table generated when you run the query.  Then, select the table or query, select Text File in the Export group of the Ribbon, select Delimited in the Export Text Wizard dialog, and proceed through the steps of the Wizard, selecting Tab as the delimiter on the 2nd screen:
Selecting Tab delimiter
EdLBAuthor Commented:
That is great! Thanks, saves me lots of time.
EdLBAuthor Commented:
One clarification that should be added to the answer-- When using the Export Wizard, DO NOT click on the button "Export data with formatting and layout."  If this option is selected, the wizard does not provide the screen shown in your comment as the 2nd screen.  Thanks again Helen.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.