Solved

Exporting Access table to tab delimited text file

Posted on 2014-12-08
3
183 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 36

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

Independent Software Vendors: 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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

726 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