Re: Oracle DB conversion to ACCESS

Import your Oracle db via ODBC in MS Access (be sure to create an ODBC connection first).

On your own PC:

1.  Create an ODBC connection to your Oracle DB
2.  Create an Access .mdb file (e.g. test.mdb).
3.  Open the Access .mdb file.
4.  Go to the table section
5.  Right click in a blank area and select "Import"
6.  At the bottom of the import dialogue box, you will see "Files of type:"
7.  Choose the "ODBC Datebases ()" option from the dropdown.
8.  Select the connection you created to your Oracle DB.
9.  Pick the tables you want, click ok when you're done, and voila!

Hope this helps....

"malvin10" <member34845_at_dbforums.com> wrote in message news:3194933.1059901305_at_dbforums.com...
>
> I've been given a project to convert data from my company's main Oracle
> DB into my own DB (Microsoft Access) from my own PC. I was wondering how
> to go about doing it. What kind of scripts or software would i need.
> Much thanks to those that are willing to help.
>
> --
> Posted via http://dbforums.com
Received on Mon Aug 04 2003 - 07:18:43 CEST