EMS Data Import for SQL Server is 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 to SQL Server tables. It provides adjustable import parameters, including source data formats for all the fields and destination 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 import options for different files visually, and a command-line utility to execute import in one-touch.
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
Adjustable import parameters for each source file
Saving all import parameters set on current wizard session
Command-line utility to import data using the configuration file
Powerful visual options module
User-friendly wizard interface
300-megahertz (MHz) Pentium II-compatible or faster processor; 600--megahertz (MHz) or faster processor recommended
Microsoft Windows NT4 with SP4 or later, Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows Vista
64 MB RAM or more; 128 MB or more recommended
20MB of available HD space for program installation
Super VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution video adapter and monitor recommended
Microsoft Mouse or compatible pointing device
Microsoft Data Access Components (MDAC) or SQL Server Native Client
Possibility to connect to any local or remote SQL Server
What’s new in Data Import version 3.1:
Added a possibility to import data from the text of XML documents embedded nodes.
Added a possibility to explicitly specify the data file for the console version using the -datafile=<source file name> parameter. Now you can use one and the same template file to import from several data files of the same type.
Added auto-recognition of columns and autofill of table fields for TXT files.
Wizard window is now resizable.
The field type is now displayed for DBF files.
Unicode data are now imported into NTEXT type fields correctly (SQL Server).
Fixed a connection error that occurred on attempt to establish connection to SQL Server 2000, when running the utility in Windows Vista environment and using SQL authentication (SQL Server).
Import to NCLOB type fields is now supported (Oracle).
In some cases an error occurred upon import of DATE data in the Native mode CSV Insert. Fixed now (MySQL).
Other minor improvements and bugfixes.
Info Hash: 7cee6250bbe757da4c5f02b3801d13bbab7ddd78
install, read the readme.txt for patching instructions
while i can guarantee that MY releases don't have viruses, if you get install files from somewhere else, i can't guarantee shit. so don't come bitching to me.
so do yourself and me a favor and download my ENTIRE release.