Solved

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

Posted on 2015-01-09
3
222 Views
Last Modified: 2015-01-10
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.
0
Comment
Question by:EdLB
  • 2
3 Comments
 
LVL 31

Accepted Solution

by:
Helen_Feddema earned 500 total points
ID: 40541951
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
0
 

Author Closing Comment

by:EdLB
ID: 40542136
That is great! Thanks, saves me lots of time.
0
 

Author Comment

by:EdLB
ID: 40542153
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.
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now