Excel sheet to store into database

I want to know how 开发者_运维百科to store the excel sheet(like payslip it's contain image also) into sql server 2005 database using asp.net

Please guide me.

---

Look at using a BLOB field:

http://www.codeproject.com/KB/database/Store_and_manipulat_BLOBs.aspx

or just store the sheet in a properly protected directory and serve it up via a ASHX handler when needed.

---

If you were using SQL Server 2008 or later, you would also have the option of using FILESTREAM storage.

---

We use varbinary(max) for storing documents in sql server. Load the document as a byte array.