Importing tables from one DB to another DB

  • Thread starter Thread starter Mike Ross
  • Start date Start date
M

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
 
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.
 
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
Click to expand...
convert it, or see the on line help.
 
Back
Top