Solved

Exporting a table into a text file without the field names in quotes

Posted on 2004-09-24
2
179 Views
Last Modified: 2006-11-17
I use the following code to export a table into a text file including the field headers. I need to however export the field headers into the text file without quotes e.g. "Field1" ---> Field1

DoCmd.TransferText acExportDelim, , "Table1", "C:\test.txt", True

I then rename the file for specific purposes using:

Name "C:\test.txt" as "C:\test.dli"

Does anyone know how to export the field headers without the quotes, or another way of removing the quotes?
0
Comment
Question by:Hodges
2 Comments
 
LVL 41

Accepted Solution

by:
shanesuebsahakarn earned 50 total points
ID: 12145531
Define an import/export spec - manually export the table via the Export Wizard. Change the field delimiter to none. On the last page of the wizard, click Advanced and save the spec. Use the spec name as the second argument of the TransferText command.
0
 

Author Comment

by:Hodges
ID: 12158284
Thanks. Works wonders.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone 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

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
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 …

827 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