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

Joined
Oct 23, 2012
Messages
29
Reaction score
0
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

Top