Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Migrating Unicode data from MS Access to Oracle
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
![]() |
![]() |