Export an Access table to an EXISTING Oracle Table

[PSULionRP]

Utilizing ODBC, can I extract a Microsoft Access Table to a table in Oracle
that already exists?

When I try, I get the message...

ORA00995: name is already used by an existing object

I would like to import to an existing Oracle Table so I don't have to play
around with the data types.

I appreciate your review and am hopeful for a response.

Thanks.

PSULionRP

 

[John Spencer]

I would think you would need an Append query to add the records to the Oracle
table.

If you are linked to the ORACLE database table then that should be fairly simple.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County