important Excel to SQL server
Hi,
I have one excel file with following structure.
Table1(with 5 columns) from row 0 to row 10
Table2(with 10 columns) from row 12 to row 21
Table3(with 3 columns) from row 23 to row 50
i want to insert this tables to my database tables.
how can i achieve in fastest way.I tried using looping thru excel
application object.but very slow.
please any ideas to achieve this.
thanks
|