create one blank database
then go to file there u will the option external date there
select import option then select from which data base u want
to retrieve all tables , if u select the tables the data
also comes along with that
Jayanth
Other MS Access Interview Questions
Question
Asked @
Answers
can primary key of one table be a primary key in many other
tables
To Refer this Site to Your Friends 
Site Map