Solved

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

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
allswap challenge 6 116
Adoquery sql  left join does not work 25 99
Apps blocked by Java 9 88
Filename to be appended with DateTimeof Download 3 62
This article will show, step by step, how to integrate R code into a R Sweave document
A short article about a problem I had getting the GPS LocationListener working.
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…

829 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