import tables in to access from another access database

[jsimha]

Dear Access Gurus,

Please help me to come out from below situation.




Have the database Total

- Containing the data that is coming from another databases
1. Source_A.mdb
2. Source_B.mdb

how to auto import the tables from source_a and source_b to datase total.

Source_A and Source_B contain the same table names, but while they importing to Totabl.mdb want to add the _A at the end of each table name.

Advice how to achive this.

Regards,
simha

[weekend00]

1 import sourceA.table into tableA
2 import sourceB.table into tableB.
3 append tableB to tableA
4 delete tableB

[jsimha]

1 import sourceA.table into tableA
2 import sourceB.table into tableB.
3 append tableB to tableA
4 delete tableB

Hi,

are you suggesting to do this in macro or vba.

Regards,
Jay

[weekend00]

it's you choice.
as to me, I seldom use Macro.

[trolleri]

1 import sourceA.table into tableA
2 import sourceB.table into tableB.
3 append tableB to tableA
4 delete tableB

Can any of you describe how to do this code in VBA in Access?