I am retrieving data from an Oracle database using ADO and want to make a mirror of a view locally, in an Access database.

Currently, I an using two sperate connections and two seperate recordset.

First I retrieve all the data from Oracle into an ADO recordset, then, one by one, I insert into the local table. this process is pretty long and I am looking for alternatives to speed things up.

Are there any techniques that would allow me to do that ?