Export Spec Problem

  • Thread starter Thread starter Bill Phillips
  • Start date Start date
B

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
 
You sure you named your saved export spec PIExport? Might you have called it
something else?
 
Back
Top