EMS logo

Products Navigation

Data Import for SQL Server

Our customers

Testimonials

When we changed our DBMS to PostgreSQL a couple of years ago, I tried many DB-clients, before I found SQLManager. The ease of use of SQLManager is impressive! The clear and well structured GUI makes the daily work done easy. In addition EMS' customer support is just fabulous! Further on: Good speed!
Markus Reidt
Nordmann, Rassmann GmbH, Hamburg

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

Live Chat with Sales rep.

Sorry, Live Chat operators are offline now. Please, leave a message and we will get back to you ASAP.

News

06/09/2014
EMS Data Import version 3.7 released
Import rate is increased; added the possibility of manual and automated identification of the type of the imported XML-file, and much more…
07/04/2012
EMS Data Import version 3.6 released
Added the "Import Empty Rows" and "Auto Trim Values" options, and much more…
11/29/2011
EMS Data Import version 3.5 released
Added the possibility to rollback the transaction, if an error occurs, import in Excel 2007 improved, and much more…
08/24/2010
EMS Data Import version 3.4 released
Support of Microsoft Office Access 2007 files and complicated date templates added, and more improvements and fixes…
12/03/2009
EMS Data Import version 3.3 released
Added the possibility to choose encodings, the support of date formats expanded, some visual changes, and much more…
02/04/2009
EMS Data Import version 3.2 released
SQL Server 2008 and PostgreSQL 8.3 support added, the possibility to create tables for imported data, and much more…

EMS Data Import for SQL Server

Overview

Download!
Buy online!

EMS Data Import for SQL Server is a powerful tool to import data to SQL Server tables from MS Excel 97-2007, MS Access, DBF, XML, TXT, CSV, MS Word 2007, RTF, ODF and HTML files. It provides adjustable import parameters, including source data formats for all the fields and destination SQL Server data formats for the selected fields, commit options, number of records to skip, etc. Data Import for SQL Server includes a wizard, which allows you to set all the SQL Server import options for different files visually, and a command-line utility to execute import to SQL Server database in one-touch.

Key Features

  • Import from 10 most popular formats: MS Excel 97-2007, MS Access, XML, DBF, TXT, CSV, MS Word 2007, OpenDocument Format and HTML
  • Importing data to one or several tables or views from different databases
  • Special batch insert commands allow to import data at the maximum possible speed
  • A number of import modes - Insert All, Insert New, Insert or Update, and others
  • UNICODE support
  • Adjustable import parameters for each source file
  • Saving all import parameters set on current wizard session
  • Automatic creation of the table structure
  • Command-line utility to import data using the configuration file
  • Powerful visual options module

In-purchase benefits

  • FREE One Year of Maintenance already included!
  • FREE software updates and upgrades during Maintenance period!
  • FREE and unlimited Technical Support during Maintenance period!
  • Reasonable pricing for Maintenance renewal – from 20% per Year!
  • Volume discounts when buying two or more copies of one product
  • Cross-selling discounts on related products
  • 30-day money-back guarantee

Product Screenshots

Enlarge

User-friendly wizard interface
Step 2 - Selecting source files

Available Versions

Data Import for SQL Server
EMS Data Import for SQL Server is a powerful tool to import your data quickly from MS Excel 97-2007, MS Access, DBF, TXT, CSV, MS Word, ODF and HTML files to SQL Server tables.

Available Interface Languages

English
English
German
German
French
French
Russian
Russian

Related Products