I've a particular requirement. I use to get an Excel Worksheet as input, containing UTF-8 encoded data, which i import into Sql Server.
There is a lot of processing done over data in sql I got through excel sheet, like Full-text population.. etc.
The point is , i need to develop a code, that should parse the Excel sheet and validate before any DTS import is done. Validation like.. for a particular column i don't need space in between , or i don't need any numeric character in any column.
One approach can be to convert that sheet into XML file and then parse it, but that will require DTD.
Can anyone help in this regard. Need a speedy solution.
Thank you in advance.
"I have Hunger for my Dream, hence chasing it "