Toad World® Forums

How to take a query using oracle and store in a MS access table

What I’m trying to do is take records out of an oracle database and store in a MS Access table using Toad Data Point.

  1. I have the Microsoft Access connection.

2 I have the Oracle connection. I need to connect the two together and merge the Oracle data into the Access table.

Couple of ways to do this,

  1. take a look and see if Access is able to connect to your oracle DB via ODBC and create an import query in access.

  2. In TOAD Create your oracle query and then use export wizard to save output to text file and then link or import MS Access to the text file

My Access connection is work now. Thanks for your help.