ODBC Access -> Oracle (errors 911/3146)

[penciled]

Hallo,
I'm trying to export an Access db to Oracle but I'm having troubles. Nothing seems to be working. I'm getting an ODBC--call failed, followed by an invalid character (#911) error.
I've created a few test tables making sure that no invalid characters are present, but the error persists.
I would appreciate greatly any help at all.
Thanks,
-Me

 

[mgavidia]

First, make sure the data types in Access correspond to the equivalent data types in Oracle. ( I actually make the columns names the same in Acces ansd in Oracle to avoid problems like this).

Second, if you're sure that everything is Ok with the data, your problem might be your ODBC. If you keep having ODBC failed errors, I'll suggest you reconfigure your ODBC connection using the Microsoft ODBC for Oracle. I found this version to be more reliable than the Oracle version itself. (It comes with Microsoft Office 97, 2000).

Good Luck!