Loading Excel File into Oracle Table

[raviva]

Hi,

I need to create a script [preferably Unix+sqlldr] to load Excel file into oracle tables. Please help if you have worked on anything like this. I have been doing this converting Excel to CSV manually and then running the script(sqlloade r). Is there a script which can automate this process.

Thanks
Ravi

[debasisdas]

from what source you are creating the excel sheet ?

[raviva]

I download the file from a website, it will be in excel format. then i save it as csv and then ftp it to unix box and run the sqlloader...

from what source you are creating the excel sheet ?

[raviva]

Any idea on this??

Ravi

I download the file from a website, it will be in excel format. then i save it as csv and then ftp it to unix box and run the sqlloader...

[amitpatel66]

SO what is the problem now??
Is your sql ldr not uploading the data properly or something??

[raviva]

All I am doing is downloading the excel file and converting the excel file into CSV(manually). I wanted to know is there a automated process which converts the excel file into csv?

SO what is the problem now??
Is your sql ldr not uploading the data properly or something??

[amitpatel66]

All I am doing is downloading the excel file and converting the excel file into CSV(manually). I wanted to know is there a automated process which converts the excel file into csv?

No there is no such automated process as such.Did you try save as .csv when you download from the server and use that file for uploading data?