How to import an excel file into a database table as binary type by using SQL Server Management Studio

Question

I have an excel file. I just would like to import the excel file into a table ExcelFiles without using c# code.

ExcelFiles has 3 columns

ExcelId, ExcelName,    ExcelFile
int       varchar(50),  varbinary(max)

I would like to import excel file into this table through SQL Server Management Studio without using c#.

Bruno · Accepted Answer · 2015-04-20 14:40:38Z

2

INSERT INTO ExcelFiles
(ExcelId, ExcelName, ExcelFile)
SELECT 1, 'filename', * FROM OPENROWSET(BULK N'C:\filename.xslx', SINGLE_BLOB) rs

answered Apr 20, 2015 at 14:40

Bruno

4,6757 gold badges65 silver badges117 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1