Access Select From External Access Database with path entered as Input parameter in query

Oct 23, 2012
Reaction score
HiI just can't find the solution to my problemI have two MS Access databasesfor ex. DataBase1.mdb,DataBase2.mdbwhat i neeed is to create query in DataBase2 that select some data from table that exists in DataBase1and i need to have DataBase1 Path as Input parameter in the queryThe latest solution i've got is

INSERT INTO DataBase2.Table2 ( Col1,Col2) SELECT*FROM Table1 IN "C:\Users\Documents\DataBase1.mdb"
i need to replace the path with an input parameter
i will appriciate any help
Last edited:


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question