Code to export text without quotes (1 Viewer)

I am trying to automate the process of exporting a database to a comma delimited txt file but I can not find a way to remove the quotes Access insists on putting around the fields. Any body know of a way?

DoCmd.TransferText acExportDelim, , "BidtekRejoinReport", _
"C:\DatabaseText.txt", False

You need to set up an export specification, and then reference it as the second argument to the DoCmd.TransferText method.

Select or open the table you wish to export, choose SaveAs/Export from the File menu, select "To an External File or Database" and click OK. Change the SaveAsType to "Text Files" and, if necessary, change the file name and/or location. Click the Export button to fire up the Export Text Wizard. On the wizard's first screen, click the Advanced button, change the TextQualifier from [quotation mark] to "{None}", click the SaveAs button, change the specification name if necessary, and click OK to save it. Then click Cancel twice to abort the process. You can now use this specification as an argument to the DoCmd.TransferText method.

Thanks, AlanS!

I must of missed a step or am not referencing it right. This is what I have:

DoCmd.TransferText acExportDelim, BidtekExport, "BidtekRejoinReport", _
"C:\Bidtek.txt", False

What am I doing wrong?

I have it now, I forgot to put quotes around the specification name. Thanks again!