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
Koen Verbeeck
SSC Guru
Points: 259085
More actions
August 1, 2013 at 3:05 am
#1637693
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 questionMy blog at https://sqlkover.com.MCSE Business Intelligence - Microsoft Data Platform MVP