Post reply

DTS a excel worksheet to table with identity column

  • July 4, 2007 at 7:35 am

    #68594

    Hi guys

    Does anyone know how I can DTS .xls file to a table that has an identity column that does not allow nulls?. The spreadsheet has a blank column which is equivalent to the identity column of the table. Thanks

     

  • July 4, 2007 at 7:40 am

    #717163

    While importing data from excel map only the columns for which data needs to come from excel omit the identity column so that it gets populated for every riow in excel when it is inserted.

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

  • July 4, 2007 at 7:58 am

    #717169

    thanks it worked like a charm

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

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