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.
Publisher description
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
Related Programs
EMS Data Import 2007 for SQL Server 3.3
Tool to import data to Microsoft SQL tables.
EMS Data Import 2005 for DB2 3.3
Tool to import data quickly to DB2 tables.
EMS Data Import 2005 for MySQL 3.3
Tool to import data quickly to MySQL tables.
EMS Data Import 2005 for PostgreSQL 3.3
Tool to import data to PostgreSQL tables.
EMS Data Import 2005 for InterBase/Firebird 3.3
Import data to InterBase/FireBird tables.
