Uploading Excel Data with internal validation

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.

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

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

Yes .. You can