SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Inserting from MS Access table to oracle - memo to clob

840187Mar 10 2011 — edited Mar 10 2011

Hi guys,

I set up an oracle odbc connection on my local machine. I am able to link to the oracle tables from ms access via this connection such that I can see the tables in access.
I want to insert the data from ms-access table into a blank table on access. I can successfull insert other fields but I'm unable to use the 'insert into oracletable select column from accesstable' syntax to insert the memo field into the clob field.
Is it possible to do this? Can someone help?

Thanks

Sam

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 7 2011

Added on Mar 10 2011

1 comment

393 views