Importing tables from one DB to another DB

[Mike Ross]

Is there a way to code (VBA) the importing of tables from
one Access DB to the current DB. I would like to create a
form for some users to push allowing them to copy full
table structures and data from an Access DB to the DB they
are currently working with.

Thanks

Mike

 

[Guest]

Doesn't
docmd.transferdatabase give you waht you want?
Buils up the command using hte macro builder and then convert it, or see the on line help.

Apologies if I have misunderstood your question.

 

[mike ross]

Thanks for the information. This is what I was looking
for. One more question on this topic. Is there a way to
import the relationships along with the tables? I can do
this through the Import drop down meuns and options, yet I
can not find a way to do this with the transferdatabase
method.

Thanks again.

Mike

-----Original Message-----
Doesn't
docmd.transferdatabase give you waht you want?
Buils up the command using hte macro builder and then

convert it, or see the on line help.