Import NCLOB field from Oracle to MS Access 2003

G

Guest

When I try to import external data from Oracle to MS Access 2003 using Oracle
ODBC Driver, I got error saying "ORA-24806: LOB form mismatch (#24806)".
In the Oracle table, we do have a NCLOB column. It's a LOB and it is
unicode. I wonder whether MS Access has any way to read this kind of info.

Thanks
 
G

Guest

When I try to use Active X control and a ADO control I get Mismatch errors
sometime. Double check you references in you code. If you do not know where
the referneces are they are under tools> References when in the Module
section. The database can not run both and the sametime. One or the other.
 
G

Guest

Thank you for the response.
But, I am actually doing the import from MS Access application/File/Get
External Data/Import. I don't have to do the reference. Or, I can do the
reference in MS Access?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

access 2003 - ODBC oracle 1
Error: Cannot add MS ODBC for Oracle 1
Access 2007 ODBC for Oracle linked table issue 0
Field Values When Linking to an Oracle Table 1
Get Data From Oracle DB Into Access?? 1
Can I import table from oracle to MS access by Transfertext? 4
Access 2003 ODBC to Oracle CLOB field show in Access text type 0
[oracle][odbc][ora]ORA-00942: table or view does not exist (#942) 1

Top