Dynamic Generic XL Upload With Validation in C#
-
This is from Chandrakanth. I need some Guidance regarding Dynamic Generic XL Upload With Validation. Can any one give me some suggestion for this Dynamic Generic XL Upload in C#. That means in MY Excel sheet in non -specific fields that means... In my excel sheet fields are not fixed it may be 5 columns,it may be 10 columns. I have to do this excel uploading with validation ,, while I am doing this excel upload I have to map with stored procedure.. and column data types... Developer does not involve on every uploading coding part...that means we have to facilitate to end user Excel uploading any file regardless of fields and data types has to upload with validation... We have to make general Excel Uploading ,,,,,, with validation using SSIS feature in SQL SERVER 2005 If u have any Idea(any other logic) to do generic excel uploading,,please share with me ... Thanks in Advance Chandrakanth.Gaddam
Chandrakanth