Loading from .xls file in SQL*Loader

[EvansEd]

I have a .xls file with double-byte characters (e.g. Chinese lettters). If I save this file as a .CSV,.DAT, etc, I loose the double-byte characters.

Does anyone know how I can load a .xls file using SQL*LOADER w/o losing the double-byte characters?

 

[vivekm]

Hi,

Try the following application. There is a free version available.

http://www.dataload.net/

Cheers,
Vivek

 

[Leon1977]

You can do something else
save the xls file to csv file and then you have problem iserting it via SQL Loader

 

[Leon1977]

NO PROBLEM .. was what I meant

 

[EvansEd]

DATALOAD did not work because my Oracle is on a UNIX box, not Windows.

If I convert my .xls file to .csv, it looses the Chinese characters, they turn into '?' (question marks), therefore I can't do that!

Any other suggestions would be greatly appreciated!

 

[comgrit]

If the data is not too much and it is one time task, sometimes I found that an ODBC connection might be easier than SQL*Loader.

Here's what I did -
1.Create a blank MS Access database.
2. Create linked table in MS Access pointed to the destination table in Oracle. * make sure that you select the primary key during the link, otherwise you can not add or update records.
3. a simple cut-paste operation between Excel to MS Acess linked table.

Hope this helps.