Copy tables between access databases

Question

I have two access databases and would like to find a way to copy tables from one database to the other. The copied table has to keep the same strucure and data.

I already tried to fiddle around with sqlBulkcopy but all information i can found about it is using sqlBulkCopy to tranfer tables to sql server.

Can I use sqlBulkCopy to copy tables between mdb files or is there another way to do this ?

Answer 1

Data transformation services?

Answer 2

Try this:

insert into [AccessTable] 
    select * from [MS Access;DATABASE=D:\My Documents\db2.mdb].[AccessTable2]