View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hemant Hemant is offline
external usenet poster
 
Posts: 12
Default 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