Can you load an excel file directly into a table using SQL*Loader? If so, how do you do it? Thanks
Printable View
Can you load an excel file directly into a table using SQL*Loader? If so, how do you do it? Thanks
The simplest way is to save the excel file as a text delimited file, then use SQL*Loader to load into oracle database.
Recently, i came to know that an Excel file can be downloaded into Oracle or any database type using an addin utility, SQL*XL.
SQL*XL is a bridge between Excel and databases.
Check out this site: [url=http://www.oraxcel.com]SQL*XL: Oracle to Excel bridge. Brings Database access native into Excel.[/url]
*** Innila ***