Solved

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

Posted on 2015-01-09
3
239 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
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 …
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

719 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