Dear Guys,
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.
Thanks
Paresh
Printable View
Dear Guys,
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.
Thanks
Paresh
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...
any suggestions??
Paresh
Win :
Abhay.Code:Rename MY_FILE.xls MY_FILE.csv
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"?