Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2013-01-14
7
Medium Priority
?
5,901 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
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

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 2000 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

885 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