Import excel files to sql server

• satishthota

  SSC Eights!

  Points: 959

  More actions

  July 18, 2008 at 4:13 am

  #126465

  How to Import Excel files to sql server using foreachloop container?

  give me examples?

• afgone

  SSCommitted

  Points: 1551

  More actions

  July 18, 2008 at 4:19 am

  #844885

  http://bi-polar23.blogspot.com/2007/08/loading-multiple-excel-files-with-ssis.html

• SrikanthSv

  Ten Centuries

  Points: 1197

  More actions

  July 18, 2008 at 5:44 am

  #844936

  As long as all the excel files have the same structure these files can be imported using a for each loop. If not it is not possible.

  So please check the requirement

  Regards
  Venkat
  http://sqlblogging.blogspot.com[/url]