EMS Data Import for SQL Server

Import data from MS Excel, MS Access, DBF, TXT, CSV, XML files to MS SQL tables.

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

Changes: Added the possibility to automatically form fields when importing from TXT, CSV and XML formats to a new table. Now the user can choose the necessary encoding, including UTF8, when importing from DBF files. Other improvements and bugfixes.

Minimum requirements: Pentium 300; 32 MB RAM; Possibility to connect to some local or remote Microsoft SQL Server

Operating system: WinXP,WinVista,WinVista x64,Win7 x32,Win7 x64,Win2000,Windows2000,Windows2003,WinServer,Windows Vista Ultimate,Windows Vista Ultimate x64,WinNT 4.x,Windows Media Center Edition 2005,Windows Vista Starter,Windows Vista Home Basic,Windows Vista Home Premium,Windows Vista Business,Windows Vista Enterprise,Windows Vista Home Basic x64,Windows Vista Home Premium x64,Windows Vista Business x64,Windows Vista Enterprise x64

Program URL: http://www.sqlmanager.net/products/mssql/dataimport

EMS Data Import for SQL Server screenshot

...

We are pleased to announce new version of EMS Data Import for SQL Server - a powerful tool to import your data quickly from MS Excel 97-2007, MS Access, DBF, XML, TXT, CSV, MS Word 2007, ODF and HTML files into your database tables.

Special permissions

The trial version of this product can be freely distributed over the internet in an unchanged form.

EULA

http://www.sqlmanager.net/products/mssql/dataimport/license

Read more