how to export from microsoft access 2010 to txt (tab delimited)

hi

i want to export some data from access to some software and i need to format the data in a text tab delimited format, and i tried to do this with this method

DoCmd.TransferText acExportDelim, , "ActionQ", "C:\Query2.txt", True, ""

the code works fine, but the problem is that the data that i exported in the text file is with Quotation mark and commas  around every part of data like this:

"01/01/2012","test"


but i need clean data and just a tab between every cell is there some other method that will export without any extra characters?
bill201Asked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
<is there some way not to delete the data in the file and just to add the new data in another row? > to the text file ?

it can be done, but you need more VBA codes to accomplish that.

and you can not use this command line anymore

DoCmd.TransferText acExportDelim, "ExportSpecName" , "ActionQ", "C:\Query2.txt", True, ""

and i suggest that you post another Q for that purpose
0
 
Rey Obrero (Capricorn1)Commented:
you need to create an export specification first

1.right click on the table
2.select export > Text file
   click on Browse and locate the destination folder
3. (you can accept the proposed name or change it)
click Save, then click OK
4. In the export text wizard select the type (Delim Fixed) width
5. Follow the wizard, before clicking on Finish
     5a .Click Advanced
6. In the Export Specification dialog box Field Information List, correct any descrepancies

7. click save as, give the specification a name <-- this is the specification name that you will use in the command line below


DoCmd.TransferText acExportDelim, "ExportSpecName" , "ActionQ", "C:\Query2.txt", True, ""
0
 
bill201Author Commented:
thanks for your answer but i prefer do to it with vba code (i will need to do it daily so i prefer to do it with one single code)
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
Rey Obrero (Capricorn1)Commented:
that is why you need to create an Export Specification first.
after you have created the Specification ,  you will just use


DoCmd.TransferText acExportDelim, "ExportSpecName" , "ActionQ", "C:\Query2.txt", True, ""
0
 
bill201Author Commented:
thanks for your excellent answer

is there some way not to delete the data in the file and just to add the new data in another row?
0
 
bill201Author Commented:
ok maybe i will don't need this code

anyway thanks alot
0
 
bill201Author Commented:
dear capricorn1

i submit the question again

please give a look in the link http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27996236.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.