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.