vbnetcoder
asked on
the file specifiation does not exsist. --- DoCmd.TransferText
I have the following code:
DoCmd.TransferText transferType:=acImportDeli m, SpecificationName:="Import Withholdin gNoticeDat a", TableName:="RawData", FileName:=filepath, hasfieldnames:=True
when I run into I get an error that the text file specification does not exists even though it does. Any ideas what the issue is?
DoCmd.TransferText transferType:=acImportDeli
when I run into I get an error that the text file specification does not exists even though it does. Any ideas what the issue is?
Try to recreate the specification giving it a simple name like "x".
ASKER
same error occcured
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sounds like the acImportDelim was not compatible with the Import Specification.
Perhaps it was made for a different file type or as an export spec.....
Perhaps it was made for a different file type or as an export spec.....