<div>
Try to recreate the specification giving it a simple name like &quot;x&quot;.
</div>


<div>
Sounds like the acImportDelim was not compatible with the Import Specification. &nbsp;<br />
Perhaps it was made for a different file type or as an export spec.....
</div>


<div>
<div class="content wysiwyg-content">
I have the following code:<br />
<br />
&nbsp;DoCmd.TransferText transferType:=acImportDeli<wbr />m, SpecificationName:=&quot;Import<wbr />Withholdin<wbr />gNoticeDat<wbr />a&quot;, TableName:=&quot;RawData&quot;, FileName:=filepath, hasfieldnames:=True<br />
<br />
when I run into I get an error that the text file specification does not exists even though it does. &nbsp;Any ideas what the issue is?
</div>
</div>


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?

Try to recreate the specification giving it a simple name like &quot;x&quot;.

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

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

I have the following code:

 DoCmd.TransferText transferType:=acImportDelim, SpecificationName:=&quot;ImportWithholdingNoticeData&quot;, TableName:=&quot;RawData&quot;, 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 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.