Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Migrating Unicode data from MS Access to Oracle

Re: Migrating Unicode data from MS Access to Oracle

From: Martin T. <bilbothebagginsbab5_at_freenet.de>
Date: 14 Sep 2006 06:23:21 -0700
Message-ID: <1158240201.672243.250380@i42g2000cwa.googlegroups.com>


Shaguna 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"
>

Well, if you have the correct data in Excel, you can always save this data as Unicode text from Excel and then import this text-file in Oracle ...? Received on Thu Sep 14 2006 - 08:23:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US