Link to home
Start Free TrialLog in
Avatar of Hodges
Hodges

asked on

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

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?
ASKER CERTIFIED SOLUTION
Avatar of shanesuebsahakarn
shanesuebsahakarn
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Hodges
Hodges

ASKER

Thanks. Works wonders.