Read data from Excel and write into oracle database

[Former Member]

Hi

I want to know how can i read data from excel and write into oracle database using java.Kindly help me out to find a solution.

Thanks and Regards

Neeta

[Former Member]

Hai,

I am suggesting the solution.

I will try out and let u know soon.

Make a coma separated file from your excel file.

Assuming that your requirement allows to make a csv file.

This file may be passed as an file object to be read by java.Using JDBC you must be able to populate the data base.You can also use String Tokenizer if needed.

You do not want to go via sql Loader?

For reading the excel file itself do you want java?

[Former Member]

Hai,

I am suggesting the solution.

I will try out and let u know soon.

Make a coma separated file from your excel file.

Assuming that your requirement allows to make a csv file.

This file may be passed as an file object to be read by java.Using JDBC you must be able to populate the data base.You can also use String Tokenizer if needed.

You do not want to go via sql Loader?

For reading the excel file itself do you want java?