EMS Data Import for SQL Server is a powerful tool to import your data quickly from MS Access, MS Excel, DBF, XML, TXT and CSV files to Microsoft SQL Server or MSDE 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.
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
- 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
- Command-line utility to import data using the configuration file
- Powerful visual options module
- User-friendly wizard interface
An utility to create backup copies of SQL Azure databases to local drives.
Comments