Kumar AU

Kumar AU

  • 1.4k
  • 320
  • 62.9k

How to validate Excel sheet column names with SQL- table col

Sep 29 2015 10:29 AM
I have an Excel sheet which contains 5 columns (Name,EmpNo,Adress,PhNo,MobNo) and I have SQL Table which contains 5 columns with same names as mentioned above, so now I need to validate excel sheet againist DB Table columns before its getting uploaded, Here I need to do this validation in CLIENT SIDE Script.
Please help me how to do this

Answers (12)