SQL Importer Features

Import Multiple Files with a Click

Choose all the files you need to import and click to begin importing. Spend your time on next steps while bulk import brings your data in.

Optimize Column Lengths

SQL Importer will accurately size your columns so they're not a byte longer than they need to be. It will even change column data types to TEXT or CLOB if a value exceeds varchar or nvarchar/unicode limits.

Fix Broken Records

SQL Importer will attempt to piece together and fix records that break onto even multiple new lines, helping prevent unecessary problems or incorrectly imported records.

Duplicate Column Name Correction

Files sometimes include header rows that use the same column name more than once. SQL Importer will rename them for you automatically.

Auto Detect File Type

Import a group of files delimited in different ways and let SQL Importer determine the file type for you. It will also detect fixed-width data.

Intelligent Data Types

Let SQL Importer analyze your data to intelligently assign Boolean, Currency, Date/Time, Decimal, and Integer data types.

Prevent Import Failures

Bad, unparsable records can be kicked out and written to an exceptions table while your import carries on. SQL Importer can also show you broken records that were fixed.

Two Built-in Parsers

Choose from two file parsing methods that use different logic to interpret your files. With SQL Importer, you have a fallback method to read in your files.

Add and Remove Columns

Sometimes records are missing columns or have extra columns. SQL Importer can optionally add or remove columns to make otherwise bad records parsable.

Fixed-Width Support

Create a simple csv layout file (.lyt) to import fixed-width text files with less difficulty. The layout file is flexible and can even be used to name your columns.

Define File Type

The 'Define File Type' feature allows the user to define file characteristics when 'Auto Detect File Type' is turned off.

Works with your Favorite Database

Create basic connections to six database platforms including SQL Server®, Oracle®, MySQL®, PostgreSQL®, MariaDB®, and Snowflake®.

Null Column Definition

Choose whether tables SQL Importer creates will have columns that default to null or not null.

Table Structures Only

Optionally use SQL Importer to create table structures only. It will create them quickly, complete with support for optimized column lengths and Intelligent Data Types.

Header-Based or Generic Column Names

Choose to have SQL Importer name columns from header rows on input files, or simply have it use generic column names.

Append Special Columns

Append information to each record including the import date and time, original source filename, and an identity/sequence column.

Replace Carriage Returns and Linefeeds

Eliminate embedded replace carriage return and line feed characters in data by having SQL Importer replace them with spaces.

Drop Table Warning

Prevent accidentally replacing a table that already exists. When enabled, a simple warning appears requesting confirmation that it's okay to replace an existing table.

Trim Leading and Trailing Spaces

Automatically do the little things as you import, such as removing leading spaces, trailing spaces, or both from your data.

History Table

Let SQL Importer store imported filenames, import date, record count, exception counts, and more in a database-specific History table.

Dark Mode

Prefer working in the dark? Toggle 'Dark Mode to switch between light and dark application themes.