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
Solved

Exporting Access table to tab delimited text file

Posted on 2014-12-08
3
181 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
3 Comments
 
LVL 35

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

808 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