how to export from microsoft access 2010 to txt (tab delimited)
Posted on 2013-01-14
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:
but i need clean data and just a tab between every cell is there some other method that will export without any extra characters?