Access to Access Import

[darno]

I have two identical databases, ASD.mdb and ASD1.mdb i wish to transfer the old database (ASD.mdb) data to the new database (ASD1.mdb). is there a way to do it. If yes please help me.

Regards

Darno

 

[MStef]

Hello Darno!
Open ASD1.mdb, click on FILE, GET EXTERNAL DATA,
IMPORT. In import window choose ASD.mdb and s.o.

 

[darno]

Access to Access Import Automation

Thanks a lot but is there a way to automate the whole process, i mean via macro or VB. Please advice if you know something similar to this. Thanks

Regards,

Darno

 

[MStef]

Yes, it's possible, try with DoCmd.CopyObject.
Look at Access help "CopyObject method".

 

[Bat17]

What are you trying to achieve? There is always more than one way to skin a cat in Access and knowing why you want to move data will probaly help someone come up with the best method.
does it matter which db you run the code from, ie can the data be pulled or must it be pushed?
As you want this in code I assume it is not to be a one off?


peter