Access 2007 - Still Having Difficult w/ Export Specifications
Posted on 2010-08-13
I created an Export Specification (to export a table as a .csv file).
With my code, I use the DCmd.TransferText to export the data on the fly, as such:
DoCmd.TransferText acExportDelim, "quick4", "Table406", "H:\Moxy60\Interface\quick4.csv"
Every time I run my code, I get the following error:
'The text file specification 'quick4' does not exist. You cannot import, export, or link using the speciification'
I then look under Saved Exports and it IS there. I can even run it from there. Any ideas????