ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   important Excel to SQL server (https://www.excelbanter.com/excel-programming/408658-important-excel-sql-server.html)

Hemant

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






All times are GMT +1. The time now is 05:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com