I am trying to import an Excel file filled with data to a
table in SQL Server. The 1st column of my table in the DB
is an identity, so I don't include this column in my Excel
file and assume that when the import happens, it will
trigger the addition of the idetity values and insert the
right values automatically, like what happens when we
use "insert" statement manually. But it does not work this
way! The import utility is smart enough to figure out the
one-to-one mapping for all columns, and "ignore" the first
column. But when the import starts, it fails and complains
the 1st column in the db can't be inserted NULL.
HOw can I work around this?
Thank you in advance.