I have to read from excel file and update a tbl in sql server.
Partial code is :
Problem I have with this code is 1)it does not read the first row 2)idnumber has numeric, alpha and alphanumeric values. If the second row has numeric value then if it returns null for rest of the alpha and alphanumeric value. If the second row has alpha value then it return null for the numeric and alphanumeric values.