the file specifiation does not exsist.    ---  DoCmd.TransferText

vbnetcoder used Ask the Experts™
I have the following code:

 DoCmd.TransferText transferType:=acImportDelim, SpecificationName:="ImportWithholdingNoticeData", 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?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2015
Distinguished Expert 2018

Try to recreate the specification giving it a simple name like "x".


same error occcured
i had to create the import spec a different way
Mark EdwardsChief Technology Officer

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.....

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial