Re: Migrate Unicode data from MS Access to Oracle

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Have you tried using ADO?

--
Brendan Reynolds
Access MVP

<shaguna.dhall@xxxxxxxxxxxxxxx> wrote in message
news:1158231842.162989.208640@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: Migrate Unicode data from MS Access to Oracle
    ... Can you link directly to the Oracle tables and use an Append query? ... and the Unicode data got converted to ASCII ... (Access-To-Oracle by Intelligent Converters). ... So the problem boils down to ...
    (microsoft.public.access.conversion)
  • Re: ANSI or Unicode
    ... > is Unicode characters (a char array or string), ... Nowhere in the process does is ANSI encoding ... otherwise I want to use standard ANSI encoding. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Migrating Unicode data from MS Access to Oracle
    ... in ANSI encoding, and the Unicode data got converted to ASCII ... (Access-To-Oracle by Intelligent Converters). ... Well, if you have the correct data in Excel, you can always save this ...
    (comp.databases.oracle.server)
  • Re: Unicode Optimization
    ... I'm using Unicode text file as embedded resource ... After some research I tried to convert this file to ANSI encoding and the ...
    (microsoft.public.dotnet.languages.csharp)
  • ANSI encoding in VB.NET
    ... I need to use ANSI encoding in VB.NET, but can't seem to find it, can anyone ... ASCII ... Unicode, and a method ... Richard ...
    (microsoft.public.dotnet.languages.vb)