Re: Access database in to oracle.

Sridhar,

    I don't know about any tools, but using ODBC you can load your data from access into an oracle database. All you need to do is install the following : Oracle SQL*NET and ODBC from a client software cd or if your databases are running on nt you should be able to get the same cd for the client installation.
Once installed you need to set up your sqlnet connect string to point to the database, use the tnsping utility. Then use the ODBC 32 bit administrator to set up an odbc connection.
Finally on your access database end you create a link table pointing to the Oracle database table you would like to load. A simple sql statement and all the data is transferred to oracle database. Allan.
----- Original Message -----
From: "Sridhar Moparthy" <sridhar.moparthy_at_wcom.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, November 10, 2000 1:57 PM
Subject: Access database in to oracle.

> Hi All,
>
> Are there any(free) tools available to load MS Access tables in to oracle
> 8.x database .
>
>
> Thanks In Advance.
> Sridhar Moparthy.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sridhar Moparthy
> INET: sridhar.moparthy_at_wcom.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Nov 10 2000 - 12:17:06 CST