I'm trying to import a text file through VB in to Access97. with the following code
DoCmd.TransferText acImportDelim, Specification1, TarTable1, SourceFile, True
While using this I'm getting an error message
"The Microsoft Jet database engine cannot find the input table or Query 'MySysIMEXSpecs' Make sure it exists and that its name is spelled correctly"
When I use the same code in the Access module it is working fine without any error.
But the problem is when I'm using it from a VB programme.