EMS Data Import for SQL Server

What is EMS Data Import for SQL Server?

EMS Data Import for SQL Server is a powerful tool for importing data into SQL Server tables from MS Excel, MS Access, DBF, XML, TXT, CSV, MS Word, RTF, ODF, and HTML files.

It provides adjustable import parameters, including source data formats for all SQL Server target data fields and data formats for the selected fields, commit options, number of records to ignore, and more. Data Import for SQL Server includes a wizard, which allows you to visually set all SQL Server import options for different files, and a command-line utility to perform SQL Server database import in one touch.

Core features

• Import from the 10 most popular formats: MS Excel, MS Access, XML, DBF, TXT, CSV, MS Word, OpenDocument Format, and HTML.
• Importing data to one or more tables or visualizations from different databases.
• Special batch insertion commands allow you to import data at the maximum possible speed.
• Multiple import modes - Insert all, insert new, insert or update and others.
• UNICODE support.
• Adjustable import parameters for each source file.
• Saving all import parameters defined in the current wizard session.
• Automatic creation of the table structure.
• Command-line utility for importing data using the configuration file.
• Powerful module of visual options.
• Amazon RDS support for SQL Server, Azure SQL database.

System requirements

Microsoft Windows XP, Microsoft Windows 2003 Server, Windows 2008 Server, Microsoft Windows Vista, Microsoft Windows 7, Microsoft Windows 8, Microsoft Windows 8.1, Microsoft Windows 10

512 MB of RAM or more

50 MB of available HD space for program installation

MDAC (Microsoft Data Access Components) ou SQL Server Native Client

Possibility to connect to any local or remote SQL Server