Creating an MDB based on an Oracle query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Oracle database. I want build an MDB based on the results of
queries run against this Oracle database. Does anyone know the best way to do
this. I was thinking of using ADO to connect to the Oracle database and run a
query. Then I was going to connect to the MDB file and use the
recordset.update command to update the MDB. I'm not sure if this is the most
efficient way to do this. Any help would be greatly appreciated.
 
Just an idea,

Take advantage of the new xml features in access, if you have 2003. export the infrmation from the oracle and just map it directly into the mdb.

HTH

Regards

Greg
 
Back
Top