importing from another db

[Guest]

Hi All,
I have an application I have created that gets information form both
local and linked tables. The local tables are imported from another database
that is downloaded from an outside source on a weekly basis. I am setting up
process that enables the user to select which weeks db they want data to come
from and have the correct tables imported into the db. I have used the
Docmd.transferdatabase method and as the database file path would change I
have set a string data type to read the file path and used this in the docmd
function. I thought this would work but it doesn't.

eg. this example should import the table "Aim" from the downloaded database
into the current database.

DoCmd.TransferDatabase acImport, "Microsoft Access", dbselect, acTable, "Aim"

any suggestions on where i'm going wrong are welcome, thanks

 

[Guest]

I've sorted it now. Forgot to put my destination on.