Import data from MS Excel, MS Access, DBF, TXT, CSV, XML files to MS SQL tables. EMS Data Import for SQL Server is a strong 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.

The necessity to import information from different sources (for example, files) into DBMS tables arises quite often when working with tools for database administration. The task may involve importing a large amount of data or performing import operation every hour. And the size of imported data can be so big that it for sure affects the time the import process requires.

EMS Data Import allows you to efficiently import data from most popular formats into database tables on supported DBMS. The utility comes in separate editions for each of the most widely used DBMS servers (SQL Server, ORACLE, MySQL, PostgreSQL, InterBase/Firebird, DB2) and uses native access to the server, which ensures maximum productivity during import process and reduces the time required to import a large amount of information.

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

Key Advantages
1. Import of information from most popular file formats
EMS Data Import supports almost all widespread formats of the source files, which rules out any preliminary conversion hassle. Text files, spreadsheets, local databases, information from web pages - all this can be easily imported into database tables with the help of Data Import.

2. Import from several files and/or into several tables simultaneously
EMS Data Import allows setting the import procedure for each file separately. Import into one or several tables, located in one or different databases is also possible.

3. High working speed
EMS Data Import is specially optimized to guarantee high import speed. Native access to database server ensures maximum productivity during information transfer and allows you to use the architectural features of the chosen DBMS with maximum efficiency.

4. UNICODE support
EMS Data Import supports UNICODE, which allows you to import data stored in different languages without any risks of damaging the information.

5. Adjustable import parameters
EMS Data Import provides a number of adjustable import parameters, such as source formats for all fields, destination formats for selected fields, commit options, the number of records to skip and many others. All parameters can be saved in the configuration file and used in future both in the GUI version of the utility and in the console one.

6. Console version to automate the import process
EMS Data Import also includes a console version that allows automate the import process; the configuration file (template) for this version is the same as the one for GUI.

Limitations:
* Imports only 20 rows

The license of this software is Free Trial Software, the price is $47.00, you can free download and get a free trial.