How to read data from an Excel Sheet into Oracle 9i database

[Anni V]

Hi

Can you please help me out with the query with the code in Oracle 9i to read records from an Excel sheet,

The Excel Sheet [Addresses.xls] Column headers are
A1-----------B1------------C1
Name----------Address-------------Contact
Mickey---------Walt Disney----------1122334455


to be displayed in the query analyser when I query it from my Oracle SQL Developer.

I successfully achieved this in SQL Server 2005 by the following code in the Query analyser:
[CODE]
SELECT *
FROM OPENROWSET('Mic rosoft.Jet.OLED B.4.0',
'Excel 8.0;Database=C: \Documents and Settings\287284 \My Documents\Addre sses.xls',
'SELECT * FROM [Sheet1$]')
[\CODE]

But please help me out how to do this in Oracle 9i


Thanks & Regards

Ani V

[debasisdas]

Convert the excel file into a CSV file.

Use SQL* LOADER to load into oracle.
Also check this.