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

F

Flona2012

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:
Back
Top