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

Kumar AU

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

12 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sujeet Suman11y ago
Accepted answer
Kumar please once try below link. This may resolve your second half problem:

http://www.dreamincode.net/forums/topic/16506-mapping-of-column-name-in-excel-file-with-database-table/
http://stackoverflow.com/questions/30331520/how-to-fetch-the-only-column-data-from-excel-which-is-there-in-database-table-co
Sujeet Suman11y ago
Your most welcome Kumar. We are here to help each other only.
Sujeet Suman11y ago
Your most welcome Kumar. We are here to help each other only.
Sujeet Suman11y ago
Your most welcome Kumar. We are here to help each other only.
Sujeet Suman11y ago
Your most welcome Kumar. We are here to help each other only.
Kumar AU11y ago
Hi Sujeet, Thank you so much for your help, my issue is resolved.
Kumar AU11y ago
Hi Sujeet, Thank you so much for your help, my issue is resolved.
Manas Mohapatra11y ago
I hope that you are getting columns from excel sheet using javascript. Then problem is solved.

Means you already know that what are columns present in your table. Suppose you have 5 columns in your table. Just check in javascript code that whether these columns are present in your excel sheet. If you get positive result then go ahead with excel sheet upload and insert data to server.
Kumar AU11y ago
Hi Sujeet, Thanks for your response. My question was different. anyway thanks for your time
Kumar AU11y ago
Thanks for your response Manas, your information resolved my half of my problem,but remaining part is how do I compare excel column name with Database table column name before I start inserting in JavaScript
Sujeet Suman11y ago
Kumar please once go through below link. This may help you:-

http://www.codeproject.com/Articles/141811/Database-to-Excel-Spreadsheet
Manas Mohapatra11y ago
Please go though below links that will help you read data from excel sheet. Then you need to implement to check your column name inside the code.

http://www.c-sharpcorner.com/code/1253/read-an-excel-file-with-javascript-without-activexobject.aspx

http://stackoverflow.com/questions/16630413/how-can-i-read-an-excel-file-with-javascript-without-activexobject