Home Forums SQL Server 2008 T-SQL (SS2K8) how to import excel file into sql server using identity column RE: how to import excel file into sql server using identity column

  • Import it into a table using SSIS. Create the table before import and add the ID column with the IDENTITY property.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP