Moving data between databases

[icemanmt78]

I want to move data between two identically structured databases. One is populated and one is empty. I wish to move/copy the data from the populated database into the empty one.

I want to be able to use DAO techniques.

At the moment i have been working on achieving this through linked tables.

Any ideas would be appreciated.

M

[RogerH]

Hi,

ohjDB.Execute "INSERT INTO Table2 SELECT * FROM Table1"

Roger

[icemanmt78]

Cheers