I am trying to export an excel file directory into an Oracle table as opposed to looping through the range and executing a lot of insert statements. I would think that there are better ways to accomplish this in .NET but I can't seem to find any other answer besides convert excel to csv & load it using Sql Loader or External Table. Does anyone know a cleaner & more efficient way that looping through the ranges creating & executing insert statements?
Thanks!
Maybe you can use some third-party xls components. For example this one: SmartXLS
Not that I recommend that, but you can use ODBC Driver for excel, to see the excel sheets as tables. Then, it is a matter of selecting the data from the excel table and insert it into Oracle table...
I think Oracle's External Tables are actually quite elegant for this (so is SQL loader). There is a 'depends' argument for either approach. However, if your looking for a more point and click solution; Oracle has a free tool called SQL Developer available for download. It has support for importing from excel.
In addition, there is an entire forum dedicated to SQL Loader and External Tables.