ODMC Table Export to Oracle

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tomg - 04 Nov 2004 19:11 GMT

I am able to export an MS-Access table to Oracle if that table does
not exist there. I would like to append data to the Oracle table, but
I get the Oracle message "Error--00955 Name is already used by an
existing object."
Is it possible to use MS Access Table Export to append to an
existing Oracle table?
thanks, tom g

Reply to this Message

MGFoster - 04 Nov 2004 22:11 GMT

> I am able to export an MS-Access table to Oracle if that table does
> not exist there. I would like to append data to the Oracle table, but
> I get the Oracle message "Error--00955 Name is already used by an
> existing object."
> Is it possible to use MS Access Table Export to append to an
> existing Oracle table?

Why not just link the Oracle table to the Access front-end & append
records using Access queries?

Signature

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Reply to this Message