Solved

Exporting Access table to tab delimited text file

Posted on 2014-12-08
3
184 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 250 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 250 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

695 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