I used Oracle migration workbench to move data between Access and Oracle
8.1.6.
--
Richard Armstrong
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 CDT
