Solved

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

Posted on 2015-01-09
3
218 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
find a node in VST 2 47
mapShare challenge 13 68
VB6 Compile Compatibility Issue 4 31
python question 5 57
I'd like to talk about something that is near and dear to my heart: build systems. Without them, building software is all about compiling locally, with software versions everywhere. It can be a mess. Today we are going to discuss building a small di…
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
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.

706 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