Excel file load in Temp table in SQL Server 2012

• saravanatn

  SSCarpal Tunnel

  Points: 4533

  More actions

  August 14, 2017 at 12:55 am

  #332199

  I want to load below value in temp table.I want to compare the register number in the below two value with each other. Problem here is Register number is sorted improperly and giving wrong result.Kindly provide any possible solution for the same. 

  Classroom	Register Number
  123	D1455,D1456,D1478
  124	E1234,F123456,T666
  125	YT567,FF123,QQ123
  Classroom	Register Number
  123	D1456,D1478,D1455
  124	E1234,T666,F123456
  125	YT567,QQ123,FF123

  Saravanan

• Thom A

  SSC Guru

  Points: 99133

  More actions

  August 14, 2017 at 1:50 am

  #1955108

  Duplicate of https://www.sqlservercentral.com/Forums/1891681/Excel-file-load-in-Temp-table-in-SQL-Server-2008, however, considering that the OP states 2012 and 2008 in their subject header, not sure what version they are actually using.

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk