Moving data between databases

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

Hi,

Code:

---

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

---

Roger

Cheers