I want to import an Excel 2003 xls file using Toad’s import wizard (menu: Tools->Import->Import Wizard). The data of the excelsheet should be imported into a table that has to be created by the wizard.
Unfortunately the wizard generates an ORA-12704 error (character set mismatch) during the import. I found out it has to do with NVARCHAR2 columns that are defined by the script generated by the wizard (so I do not get this error if none of the columns are NVARCHAR2).
Obviously the question is: how can I get rid of this error? Can the wizard generate VARCHAR2 columns as well?
I’m using Toad for Data Analists 2.7 and Oracle 8.1.7.
Message was edited by: Erik0067