Help importing Paradox table into Access with VBA

[Dan8376]

Hi,

I'm trying to import a Paradox file into my database, but I'm getting the following error:

Run-time error '3044':
'O:\DATA\ACCESS\TG070723.DB' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

Here is the code:
strLoc = "O:\DATA\ACCESS\"
strDatabase = [Forms]![frmImportDataInput]![txtDatabaseName]
DoCmd.TransferDatabase acImport, "Paradox 7.x", strLoc & strDatabase

I've checked the path, I know it is spelled correctly. I have access to the drive where the database is located. I can manually import the file by using the Get External Data command. Anyone have any suggestions on what my problem is?

Thanks
Dan

 

[mikej336]

It has been a while since I have done it but according to the docs you need....

TransferDatabase(TransferType, DatabaseType, DatabaseName, ObjectType, Source, Destination, StructureOnly, StoreLogin)

at the least you should have

'includet the file name
strLoc = "O:\DATA\ACCESS\TG070723.DB"
DoCmd.TransferDatabase acImport, "Paradox 7.x", strLoc, "tablenamehere"

Uncle Mike