Migrating Unicode data from MS Access to Oracle

From: Shaguna <shaguna.dhall_at_intrasphere.com>
Date: 14 Sep 2006 05:29:48 -0700
Message-ID: <1158236988.293302.288380@e3g2000cwe.googlegroups.com>

I need to migrate Unicode data from MS Access to Oracle. Have tried the following:

-Exported the Access tables to csv/txt, but these files were generated
in ANSI encoding, and the Unicode data got converted to ASCII characters.
-ODBC export directly to the Oracle tables doesn't work either.
-However, when the table is exported to excel, Unicode encoding is
retained.

I'm not looking for any tools as we are already using one (Access-To-Oracle by Intelligent Converters). After buying it, we realized that we needed Unicode conversion as well and that it doesn't support the same. So buying any new tools is out of question right now.

All the settings are correct in Oracle i.e. the charset and national char set are configured to Unicode. So the problem boils down to "extracting the data from the source Access DB in Unicode"

Has anyone ever encountered a similar problem?

Thanks,
Shaguna Received on Thu Sep 14 2006 - 07:29:48 CDT