470,628 Members | 2,312 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,628 developers. It's quick & easy.

Migrating Unicode data from MS Access to Oracle

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

Sep 14 '06 #1
1 3285
-ODBC export directly to the Oracle tables doesn't work either.

I dunno, I just tried it and it worked for me. My ODBC DSN uses the
"Oracle in XE" driver. I created a table in Access called [Cities] with
a single TEXT(50) column and just did a

File Export...

from Access into the ODBC data source. It created the table in Oracle
(10g Express Edition) as

CREATE TABLE "Cities"
( "City" VARCHAR2(50)
)

and populated it with the data from Access.
Gord
sh***********@intrasphere.com wrote:
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
Sep 14 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by oozyscab via AccessMonster.com | last post: by
2 posts views Thread by Ram | last post: by
24 posts views Thread by ChaosKCW | last post: by
8 posts views Thread by Richard Schulman | last post: by
1 post views Thread by SÝren Alexandersen | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.