Solved

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

Posted on 2013-01-14
7
4,343 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

770 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