import table

[slimjen]

All; using access 2010. Trying to set up an import table from an external database.

DoCmd.TransferDatabase acImport, "Microsoft Access", "Y:\DevTest\Folder\2013 01 Some Data Name", acTable, "tblName", "tblName"

I get an error 3024 could not find the file Y"\DevTest\Folder\2013....
The database I am importing from is a 2003 .mdb
I tried the brackets because the file has spaces in it but still get the same error.
What am I doing wrong please?

[ssanfu]

Try adding the extension:

DoCmd.TransferDatabase acImport, "Microsoft Access", "Y:\DevTest\Folder\2013 01 Some Data Name.mdb", acTable, "tblName", "tblName"

[slimjen]

thanks for replying. Tried this. Still getting the error. I tried taking out the spaces. Still Errors.

[ssanfu]

I just tested the command using (A2000):

DoCmd.TransferDatabase acImport, "Microsoft Access", "C:\AccMDB\cpr.mdb", acTable, "CertificationsT", "CertificationsT"

The table transfered, no problems..

Can you manually import the table?
Move the file to your computer (C drive) and try importing.
Can you manually open the database (it is not corrupt)?
You have permissions (assuming "Y" is a network drive)?

[slimjen]

Got it! Someone converted the database to 2010 without communicating to the users!! Thanks for all your help.

[ssanfu]

Great.

Might want to change the extension to " .accdb"