SQL Server Performance Forum – Threads Archive

MS Access Tables Import

I have 5 MS Access file I want to transfer all the MS Access tables from all these 5 mdb to a single mdb.How to accompolish this.
I know this is beyond the scope of this forum,but I am sure I will get some positive response from here.
I have tried with dts.It showed that the tables were transfred successfully.
But now when I am opening any access file in my system its showing error."MS Access has encountered one error…." Is there any othet way to do this easily.Some feature integrated with msaccess will be the best option

---

Aha its working fine now.But still if someone has any other techniques please post.

---

]]>