insert into SpreadsheetDataDump (f1,f2,f3,f4,f5,f6)  
Select f1,f2,f3,f4,f5,f6 
FROM OPENDATASOURCE
('Microsoft.Jet.OLEDB.4.0','Data Source="D:\spreadsheets\test.xls";Extended Properties="Excel 8.0;IMEX=1;HDR=NO"')
...WorksheetName$ 

INSERT INTO SpreadsheetDataDump (f1,f2,f3,f4,f5,f6) 
SELECT f1,f2,f3,f4,f5,f6 
FROM OPENDATASOURCE
('Microsoft.Jet.OLEDB.4.0','Data Source="D:\spreadsheets\test.xls";Extended Properties="Excel 8.0;IMEX=1;HDR=NO"')
...WorksheetName$ 

CREATE TABLE BinaryDataFiles(
[PkID] [int] IDENTITY(1,1) NOT NULL,
[FileName] [nvarchar](255) ,
[FileSize] [real],
[FileData] [image],
[UploadDate] [datetime] DEFAULT (getdate()),
[ContentType] [nvarchar](30)
)

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Diagnostics;
using System.IO;
using System.Configuration;
 
namespace StreamImageData {
class Program {
static int Main(string[] args) {
try {
string ConStr = "Data Source=theServer;Initial Catalog=theDatabase;Persist Security Info=True;User ID=theUser;Password=thePassword";
SqlConnection dbConn = new SqlConnection(ConStr);
string sql_str = "select FileSize, FileName, FileData, ContentType from BinaryDataFiles where (PkID = @PkID)";
SqlCommand cmdGetFile = new SqlCommand(sql_str, dbConn);
SqlParameter paramPkID = new SqlParameter("@PkID", SqlDbType.Int);
cmdGetFile.Parameters.Add(paramPkID);
paramPkID.Direction = ParameterDirection.Input;
paramPkID.Value = args[0].ToString(); // The primary key of the blob.
string fileName = args[1].ToString(); // The output file name.
dbConn.Open();
SqlDataReader dr;
dr = cmdGetFile.ExecuteReader();
if(dr.Read()) {
// Create random data to write to the file.
byte[] dataArray = (byte[])dr["FileData"];
using(FileStream fileStream = new FileStream(fileName, FileMode.Create)) {
// Write the data to the file, byte by byte.
for(int i = 0; i < dataArray.Length; i++) {
fileStream.WriteByte(dataArray[i]);
}
}
}
return 0;
} catch(Exception ex) {
Debug.Write(ex.ToString());
return -1;
}
}
}
}

USE [YourDatabase]
GO
CREATE PROCEDURE [dbo].[BinaryDataFiles_StreamImage2File](
@FileName AS varchar(256) 
,@ID AS varchar(64)
,@Debug AS bit = 0 --defaults to 0 (off)
)
AS
SET nocount ON 
 
DECLARE @TheResult int
declare @command_string AS nvarchar(2000) 
SET @command_string = '"d:\apps\bin\StreamImageData.exe" ' 
 + @ID + ' ' + @FileName
 
EXEC @TheResult = master.dbo.xp_cmdshell @command_string
print @TheResult
 
declare @ItExists AS int 
exec master..xp_fileexist @FileName, @ItExists out
IF @ItExists = 0 -- It failed; the file doesn't exist.
begin 
 -- Dump some kind of fail message
end 

INSERT INTO SpreadsheetDataDump (f1,f2,f3,f4,f5,f6)  
SELECT f1,f2,f3,f4,f5,f6 
FROM OPENDATASOURCE
('Microsoft.Jet.OLEDB.4.0','Data Source="D:\spreadsheets\test.xls";Extended Properties="Excel 8.0;IMEX=1;HDR=NO"')
...WorksheetName$ 

CREATE TABLE BinaryDataFiles(
[f1] [nvarchar](255) ,
[f2] [nvarchar](255) ,
[f3] [nvarchar](255) ,
[f4] [nvarchar](255) ,
[f5] [nvarchar](255) ,
[f6] [nvarchar](255)
)

declare @text_01 AS varchar(1000) 
declare @text_02 AS varchar(500)
declare @spreadsheet AS varchar(250)
declare @worksheet AS varchar(250)
declare @sql_statement AS varchar(2000)
 
SET @spreadsheet = 'c:\path\test.xls'
SET @worksheet = 'Sheet1'
 
SET @text_01 = 'INSERT INTO SpreadsheetDataDump (f1,f2,f3,f4,f5,f6) SELECT f1,f2,f3,f4,f5,f6 '
 
SET @text_02 = ' FROM OPENDATASOURCE(''Microsoft.Jet.OLEDB.4.0'',''Data Source="'
+  @spreadsheet + '";Extended Properties="Excel 8.0;IMEX=1;HDR=NO"'')...'
+  @worksheet + '$' 
 
 
SET @sql_statement =  @text_01 + @text_02
 
exec (@sql_statement )