lundi 20 avril 2015

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

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       archar(50),  varbinary(max)

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

Is this possible?

Aucun commentaire:

Enregistrer un commentaire