Post reply

Import each worksheet from Excel as a new table?

  • February 8, 2010 at 9:58 am

    #137130

    Hi! I have this awesome Excel workbook with like 90 worksheets in it. I want to import each of these worksheets as their own table using the worksheet name as part of the table's name. So if the worksheet is called This_Part I want to call the table Eff_This_Part.

    I have an SSIS package created that iterates through the workbook using an Excel source and a ForEach that then uses a variable name to slap the worksheet in memory into an SQL Destination.

    How do I dynamically create those named table?

  • February 8, 2010 at 11:46 am

    #1115699

    Figured out a T-SQL way to do it: http://www.sqlservercentral.com/Forums/Topic861880-338-1.aspx

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply