Export Spec Problem

[Bill Phillips]

I am getting run-time error 3625. The text file specification "PIExport" does
not exist. You cannot import, export or link using the specification.

I am using Access 2007 but this db is in 2003 format. I created an export
spec using the File|Export wizard. Basically it is a standard text export
with no text delimiter. Any ideas on why when I use the transfertext method
it doesn't work. Here is the VB line calling transfer text

DoCmd.TransferText acExportDelim, "PIExport", "tblExportToSX", "D:\Physical
Inventory\PIExport.txt", False

Thanks,

Bill

 

[Douglas J. Steele]

You sure you named your saved export spec PIExport? Might you have called it
something else?