469,358 Members | 1,639 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,358 developers. It's quick & easy.

Loading Excel File into Oracle Table

19
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(sqlloader). Is there a script which can automate this process.

Thanks
Ravi
Aug 1 '08 #1
6 4372
debasisdas
8,127 Expert 4TB
from what source you are creating the excel sheet ?
Aug 1 '08 #2
raviva
19
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 ?
Aug 1 '08 #3
raviva
19
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...
Aug 5 '08 #4
amitpatel66
2,367 Expert 2GB
SO what is the problem now??
Is your sql ldr not uploading the data properly or something??
Aug 5 '08 #5
raviva
19
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??
Aug 5 '08 #6
amitpatel66
2,367 Expert 2GB
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?
Aug 5 '08 #7

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Ornez | last post: by
reply views Thread by dioscuroi | last post: by
3 posts views Thread by Conrad F | last post: by
reply views Thread by ramnaresh_t yadav via .NET 247 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.