Hi,
Can I directly load MS Excel files to Oracle DB without converting it to txt or csv files?
Thanks,
Printable View
Hi,
Can I directly load MS Excel files to Oracle DB without converting it to txt or csv files?
Thanks,
You cant load Excel files directly because they are binary files.
You should export them to a comma delimited/text file and then use the sqlldr utility to load/append data to the table.
regards,
Rotem.
Thank you rotem,
There is plug-in product for Excel (SQL*XL) available that can do this.
URL: http://www.oraxcel.com
Sanjay
Thanks again San,