Re: Access 97 to Pre-Existing Oracle Table

You shouldn't you be able to design an append query in Access. Worked for me in Access 2 and Access 95.

Hth,

Sybrand Bakker, Oracle DBA

"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 Fri Jun 16 2000 - 00:00:00 CEST