Posted on 2004-04-05
I need a file exported as text using tab-delimited, no quotes around text. I created a spec in the "Export Wizard", called 'TabExportSpec' and ran the following:
DoCmd.TransferText acExportDelim, TabExportSpec, "ActionCodeResults", "C:\MFAtest\ActionCode2.txt", False
Access ignored the spec I created and used comma's and quotes anyway. Apparently my spec is in the wrong place. What Have I done wrong?