Exporting a table into a text file without the field names in quotes
Posted on 2004-09-24
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?