EMS Data Import allows for easy transfer of data from various file types, including MS Excel, Access, TXT, and HTML, into SQL Server tables. This tool streamlines the data import process, making it simple and efficient.
EMS Data Import for SQL Server comes with two utilities to cater for your specific data-importation requirements. One such utility is the wizard which visually allows you to set SQL Server import options for different files while the other is a command-line tool that makes it possible to execute import to SQL Server database with just one touch. With the EMS Data Import, importing data from different databases to a single table is now possible making the process faster and more streamlined.
EMS Data Import for SQL Server offers special batch insert commands that help increase data import speed to a maximum capacity. With the UNICODE support feature, there is enormous flexibility and support for an array of import modes including Insert All, Insert New, Insert or Update among others.
EMS Data Import for SQL Server also comes with several adjustable import parameters for each source file, and all these parameters can be saved and accessed at any time during each wizard session. This software also provides automatic creation of table structures and an excellent command-line utility to import data using the configuration file that’s been set up previously. The visual options module also comes packed with powerful attributes that greatly enhances the software user and product experience overall.
Version 3.3:
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.
Version 3.2:
- Added the possibility to create separate tables for each source data file; to choose the file character set (None, OEM, ANSI) when importing data from DBF files.
- It is now possible to specify the source data charset when importing TXT and CSV files.
and much more...
Version 3.1:
- Importing data from the text of XML documents embedded nodes
- Ability to explicitly specify the data file for the console version using the -datafile= parameter
- Auto-recognition of columns and autofill of table fields for TXT files
- Other minor improvements and bugfixes
Version 3.1:
- Importing data from the text of XML documents embedded nodes
- Ability to explicitly specify the data file for the console version using the -datafile= parameter
- Auto-recognition of columns and autofill of table fields for TXT files
- Other minor improvements and bugfixes
Version 3.0:
- The new “Native†method of import is added which includes two algorithms.
- Import from new formats.
- Identity fields support implement.
- Utility source code significantly optimized, work speed increased.
- Unicode support.
- Other improvements and bugfixes.
Version 2.2:
- The ability to import data from VisualFoxPro DBF format added.
- The amount of memory consumed is significantly decreased when importing large files.
- Other improvements and bug-fixes.