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

vbnetcoder
vbnetcoder used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

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

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

Author

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

Commented:
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