Avatar of vbnetcoder
vbnetcoder

asked on 

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

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?
Microsoft Access

Avatar of undefined
Last Comment
Mark Edwards
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

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

ASKER

same error occcured
ASKER CERTIFIED SOLUTION
Avatar of vbnetcoder
vbnetcoder

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Mark Edwards
Mark Edwards
Flag of United States of America image

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

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo