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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Oracle Connection String 1
Linking Access and Oracle Database 2
oracle fields exceed 255 3
Linking to Oracle 2
Field Values When Linking to an Oracle Table 1
how do I link to Oracle 9
How do I connect Access to Oracle if Oracle client is not installe 1
Linking to Oracle via ACCESS 1

Back
Top