EMS Data Import 2007 for SQL Server description
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 your data quickly from MS Access, MS Excel, DBF, TXT, CSV and XML files to Microsoft SQL Server or MSDE tables.EMS Data Import 2007 for SQL Server is a software that import data from MS Access.

EMS Data Import 2007 for SQL Server 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. MS SQL Import 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.

Here are some key features of "EMS Data Import 2007 for

SQL Server":

· 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
· Secure Shell (SSH) and HTTP tunneling support
· UNICODE support
· 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


Requirements:

· 300-megahertz (MHz) Pentium II-compatible or faster processor; 600--megahertz (MHz) or faster processor recommended
· 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


Limitations:

· 30-day trial period
· Imports only 20 rows