Excel file in Oracle Table
I want load data in the excel file into Oracle table.
I know we cant load excel files directly into table but is there any way I can convert excel file into CSV format.
Any suggestions are welcome.
File/Save As and then select the type to be csv!
I know by saving that file as .CSV format will covert the excel file into csv format. But is there any windows or unix utility which will convert the excel file into csv format? because i dont want to do it manually...
Rename MY_FILE.xls MY_FILE.csv
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Thanks for the reply...
when i ran above command, it creates .csv file but it contains junk characters.
Is there any other option?
If you don't find a conversion program, you could (as a last resort) make an Access db with macros that Import the Excel file and send the data to Oracle by ODBC, this kind of thing can be run from a batch. I'm sure only Bill Gates thinks that this is the ideal solution
why don't you google some "command line tool convert excel csv"?
"A common mistake that people make when trying to design something completely
foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams
Click Here to Expand Forum to Full Width