Uploading Excel Data with internal validation

**jsc0624** · May 4th, 2009, 04:54 AM

Is it possible in asp.net using c# to validate the data inside the excel files and save the validated data in the sql server 2005? Thanks in advance.

**danasegarane** · May 4th, 2009, 05:07 AM

Yes. It is Possible..You can connect to Excel using OLEDB and read the data from the Excel sheet using the query like

Code:

Select * from Sheet$1

and load the values in a Datatable and do the manipulations and validation and using then you can update the values in SQL

**jsc0624** · May 4th, 2009, 08:42 PM

Thanks very much. Can I also apply this in a 3-Tier Architecture?

**danasegarane** · May 5th, 2009, 12:24 AM

Yes .. You can

Thread: Uploading Excel Data with internal validation