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

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, ""

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)

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, ""

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?

ok maybe i will don't need this code

anyway thanks alot

dear capricorn1

i submit the question again

please give a look in the link https://www.experts-exchange.com/questions/27996236/how-to-export-from-microsoft-access-2010-to-txt-tab-delimited.html