Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Some more problems with exporting Access Table in Oracle
Actually, Metalink helped me to resolve the issue. I am using 9.2.0.1
client. It has a bug if Access Database type used is Yes/No. Once I
chanhed the data type from Yes/No to Text, I could export table
directly from Access 2000 to Oracle.
See Oracle response below:
BUG 3340917 : MS ACCESS HANGS EXPORTING YES/NO COLUMN THROUGH ORACLE ODBC DRIVER Which is fixed in the latest patches Received on Tue Jan 04 2005 - 16:02:12 CST