?
Solved

Exporting Access table to tab delimited text file

Posted on 2014-12-08
3
Medium Priority
?
186 Views
Last Modified: 2014-12-08
Is there a way to export an Access table to a tab delimited text file using vba?
I have the following line of code which creates the text file but it is comma delimited.

DoCmd.TransferText acExportDelim, , "PNLFile", "c:\temp\PNLFile.txt", False
0
Comment
Question by:dsoderstrom
[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
3 Comments
 
LVL 38

Assisted Solution

by:PatHartman
PatHartman earned 1000 total points
ID: 40487768
To create a tab delimited file, you'll need to create the export once using the wizard so you can build an export spec.  Once the Export spec is built and saved (don't forget to give it a good name when you save it), you can reference it in the TransferText Method.
0
 
LVL 18

Accepted Solution

by:
Simon earned 1000 total points
ID: 40487772
Hi, this has been asked before and Rey Obrero answered it
Link to key comment in previous Experts Exchange thread
0
 

Author Closing Comment

by:dsoderstrom
ID: 40487994
Thank you both
0

Featured Post

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

752 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