Solved

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

Posted on 2013-01-14
7
4,518 Views
Last Modified: 2013-01-15
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?
0
Comment
Question by:bill201
  • 4
  • 3
7 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38776005
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
 

Author Comment

by:bill201
ID: 38776094
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
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38776100
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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

Author Comment

by:bill201
ID: 38776166
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
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 38776183
<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
 

Author Comment

by:bill201
ID: 38776194
ok maybe i will don't need this code

anyway thanks alot
0
 

Author Comment

by:bill201
ID: 38779349
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

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
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…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

820 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