Issue with DoCmd TransferText

[BrianFawcett]

I have a button on a form which has code to delete and table and then import that same table from a network folder. When I run the job I get an error telling me "The text file specification does not exist." But it does.

Here is my code:

DoCmd.TransferText acImportDelim, "ImportOLMData", "BacklogDataTable", "C:\Documents and Settings\bfawcett\Desktop\Business Analyst - Brian Fawcett\Development\Leasing\o3916021.csv"

Does anyone know what might be wrong?

 

[GinaWhipp]

I would try going thru it manually and making sure it is showing up on the list the same way you typed it because there appears to be nothing wrong with your line.

 

[BrianFawcett]

GinaWhipp, I have done it manually. I even copied and pasted the text from the Import Spec name into the VBA code, and it still gives me the error. I am stumped as to why.

 

[GinaWhipp]

Well, my only suggestion would be to recreate it with a new name. Seems it must think it's not there or not for text...

 

[GohDiamond]

"ImportOLMData" is the text file specification in your example; I've had occasion where these things become corrupt, recreate the SPEC and override it or rename it with a 2 and fix the VB code to match...

just a suggestion...

Cheers!
Goh