Dynamically creating tables based on Excel tabs with SQL2005 64bit

• Rich Hansell

  SSCrazy

  Points: 2346

  More actions

  June 22, 2007 at 7:38 am

  #372481

  Hi all.. We are hitting a stumbling block in one of our processes. We are trying to dynamically create tables based on the import of data from an excel spreadsheet. The columns will not always be known, hence the dynamically create part. Any suggestions on how to do this with SQL2005 (64 bit) since there is no linked server provider that will interface with excel.

  TIA

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  June 22, 2007 at 7:54 am

  #714587

  In 2005 you have to use SSIS to import and export data. I hope your requirement is achieveable with SSIS and can be done perfectly.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com