Batch import EXCEL into SQL Server IMAGE / VARBINARY(MAX)

Want to batch import EXCEL files into SQL Server [IMAGE, VARBINARY(MAX)] (BLOB) column?

Try Withdata DBBlobEditor, a SQL Server [IMAGE, VARBINARY(MAX)] (BLOB) editor, Bulk import EXCEL into SQL Server, East and Fast.

Can run in GUI mode, just a few mouse clicks.
Can run in Command line, for Scheduled Tasks and Streams.
Support Windows, Linux, and macOS.

Download Withdata DBBlobEditor

Batch import EXCEL files to SQL Server [IMAGE, VARBINARY(MAX)] (BLOB) column

Run DBBlobEditor, login to SQL Server.

Batch import excel files into SQL Server [IMAGE, VARBINARY(MAX)] (BLOB) - login to SQL Server

Click “Start New Task – Import LOB From Files” at task dialog.

Batch import excel files into SQL Server [IMAGE, VARBINARY(MAX)] (BLOB) - Task Window

then show the wizard.

1. Configure import EXCEL settings.

Batch insert excel files into SQL Server [IMAGE, VARBINARY(MAX)] (BLOB) - config

2. Bulk import EXCEL files to SQL Server [IMAGE, VARBINARY(MAX)] (BLOB).

Batch save excel files into SQL Server [IMAGE, VARBINARY(MAX)] (BLOB) - import

then you can see importing results

Batch import excel files into SQL Server [IMAGE, VARBINARY(MAX)] (BLOB) - view

More about SQL Server [IMAGE, VARBINARY(MAX)] (BLOB) importer

Download Withdata DBBlobEditor

EXCEL → SQL Server reference

Type mapping

Value kind	in EXCEL	in SQL Server
Int	`1234 (a real numeric cell)`	`int`
Bigint	`9007199254740993 (exact only while the cell stays text)`	`bigint`
Decimal	`1234.56 (numeric cell, format controls the displayed decimals)`	`decimal(p,s)`
Float	`1.234E+10 (numeric cell)`	`float`
Text	`text cell; leading zeros survive only if the column is text`	`nvarchar(n)`
Long text	`text cell; wraps inside the cell rather than the row`	`nvarchar(max)`
Date	`a serial number plus a date cell format`	`date`
Datetime	`a serial number plus a date-time cell format`	`datetime2`
Binary	`not representable as data`	`varbinary(max)`
Boolean	`TRUE / FALSE (a real boolean cell)`	`bit`
JSON	`a text cell; the quotes are part of the value`	`nvarchar(max)`

Dialect differences

EXCEL is a file format and SQL Server is a database server, so the target has to be told the types the file never carried – the rows below are where the two sides diverge.

Property	in EXCEL	in SQL Server
port	`—`	`1433`
identifiers	`Not applicable; a cell holds exactly one value`	`[square brackets]`
row limit	`—`	`SELECT TOP n`
dates	`Stored as a serial number; only the cell format makes it lo...`	`datetime, datetime2, date, time`
long text	`—`	`nvarchar(max)`
binary	`Only as text or an embedded object, not as a data column`	`varbinary(max)`
separator	`Cells, not delimiters`	`—`
encoding	`UTF-8 internally, declared in the package`	`—`
typing	`Real cell types: text, number, date, boolean, error`	`—`
shape	`Multiple sheets, each a flat grid`	`Tables of rows and columns`
ceiling	`1,048,576 rows x 16,384 columns per sheet; 255 sheets per w...`	`—`

Command line

Side	Command
SQL Server	`bcp`
SQL Server (load)	`bcp, or BULK INSERT`

Convert your data online, free

Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.