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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER