Re: Access 97 to Pre-Existing Oracle Table

1. obtain and install an appropriate ODBC driver
2. In the Acess MDB, establish a link to the Oracle table of interest.

If the Access data is to REPLACE data in an EXISTING table: 3a. Create an Access DELETE query to remove the records 3b. Create an Access APPEND query to simply add the records.

Obtaining the "best" possible ODBC driver becomes very (VERY) important if you are processing many many records or if timing is critical. The ODBC driver
supplied with the Oracle CD is very slow. The driver from Microsoft may not work
with your version of SQL Net. I use Intersolv's. It is not free.

"Veto Hunter" <veto_at_erols.com> wrote in message news:394A69EA.BC25BF0C_at_erols.com...
> We're trying to move data from an Access 97 table to a pre-existing
> Oracle 8.1.6 table. We can do it programmatically, but would like to do
> it with a tool which utilizes an ODBC connection.
>
> There is an Access utility to export a table to an ODBC data source, but
> the utility creates a new table.
>
> Presently, we export the Access table to a pipe-delimited file and
> import it into Oracle using SQL*Loader. We want to get around this by
> using a straight ODBC connection.
>
> Thanks.
>
> --
> ------------------------------------------------------
> A wise man knows everything....A shrewd one, everybody
>
> - Chinese Proverb
>
> veto_at_erols.com
> ------------------------------------------------------
Received on Wed Jun 21 2000 - 00:00:00 CEST