Reads the first row as headers by default and rewrites
empty, duplicate, or symbol-laden header text into clean
SQL Server column names - reserved words are
bracket-quoted ([Order]), merged-cell layouts
are unflattened, and you can override the header row in the
wizard.
Samples real values per column and proposes one strict SQL
Server target type in the type-mapping review -
columns with numbers, dates, text, and error values mixed
together are flagged so you pick nvarchar or
widen the type rather than losing rows to silent coercion.
Reads the underlying stored value rather than the displayed
format - ZIP codes, SKUs, long IDs, and date serials
travel intact when you mark those columns as
nvarchar instead of accepting Excel's auto-typing.
Lets you map every sheet to a separate SQL Server table, or
select one range as the table, or feed several Excel files
into the same target table - pick the layout in the
wizard.
Saves the migration as a session so a recurring spreadsheet
rerun (weekly refresh, monthly load) replays the same
mapping; pick append-or-replace policy and (if you set a
primary key) deduplication semantics in the wizard.
DBConvert treats the workbook as a data source: sheets, ranges, columns, and
values become tables, columns, and rows. Formulas, workbook formatting, charts,
pivot tables, VBA macros, and Excel-only validation rules are not converted into
SQL Server business logic - those rules are reimplemented in the database or in
the application as a separate workstream.
Windows 10 or later