Excel to sql server table

• keywestfl9

  SSCertifiable

  Points: 5215

  More actions

  January 30, 2009 at 12:15 pm

  #199493

  i am trying to do data transformation from excel to sql table.

  it goes thru fine and stops at 37229.

  table desc:

  idnumber(bigint,notnull) -- identity colum

  rest of the table allows null

  at 37230 record it says null can't be inserted in the idnumber column

  anybody knows why? please let me know

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  January 30, 2009 at 1:09 pm

  #935813

  Please do not post the same question to multiple forums. Most people who like to help look in all the forums.

  Direct all answers here.

  http://www.sqlservercentral.com/Forums/Topic647237-148-1.aspx