SQL Importer Features

See it in action
team member
Take the work out of importing
Moving delimited files into your databases shouldn't be the focus of your energy. Yet cumbersome import wizards, fragile automation, and bad records are just a few things that make it more painful and costly than it should be. SQL Importer has features that make importing a breeze.
import multiple
Import multiple files with a click

Select all the files you need to import, click, and step away or watch them import. Spend your time on other things.

optimize columns
Optimize field sizes

SQL Importer will accurately size your fields so they're not a byte longer than they need to be. Imported data is stored in varchar, nvarchar/unicode, or text depending on options and string size.

fix broken records
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.

crash import
Prevent crashes

Bad records will be kicked out while your import carries on. SQL Importer can create Fixes and Exceptions tables so you can have a look.

fix duplicate column names
Duplicate column correction

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

guess delimiter
Guess the delimiter

Import a group of files delimited by different characters and let SQL Importer guess the delimiters for you.

guess delimiter
Three built-in parsers

Choose from three file parsing methods that each use different logic to interpret your files.

guess delimiter
Drop table warning

Be warned before replacing a table that already exists.

guess delimiter
Table structures only

Optionally create table structures only.

guess delimiter
Works with your favorite database

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

guess delimiter
Header based field names

Choose to use header-based or generic field names. Let SQL Importer optimize field lengths or define a global length.

guess delimiter
Allow nulls?

Let your fields include null values or not. Your tables will be created accordingly.

guess delimiter
Append special fields

Append the import date and time, original source filename, and an identity/sequence field.

guess delimiter
Replace carriage returns and line feeds

SQL Importer can replace carriage return and line feed characters in your data with blank spaces.

guess delimiter
Add or remove columns

Sometimes records are missing columns or have extra columns. You can optionally add or remove columns to make otherwise bad records consistent.

Supported Databases