My Access 2k mdb contains three tables linked with each other.

Backup - Each table separately Export to excel format. This works fine.

Restore - Each excel file separately Import in (new create) temporary table and then updatable query fires and it updates all the tables separately and tehn delete all the three temps.

With this I want to append datas from temp tables to the corresponding main table which are new ones.

But this is not working.

I think if I can Export all the linked tables in one sort and then when required Import all the Excels in single fire then it will be most feasible for me.

Pl help.