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?
Who is Participating?
shanesuebsahakarnConnect With a Mentor Commented:
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.
HodgesAuthor Commented:
Thanks. Works wonders.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.