EMS Data Import for SQL Server 3.6.0.1
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 data to SQL Server tables from MS Excel 97-2007, MS Access, DBF, XML, TXT, CSV, MS Word 2007, RTF, ODF and HTML files.
Software Specs
Publisher:............ EMS Database Management Solutions, Inc
License:............... Shareware
Price:................... $95.00
Expire: ................ 30
File size:.............. 9.28 MB
Downloads:......... 1766
Release date:...... 18 Feb 2010
Last update:........ 14 May 2014
Language:............ English, French, German, Italian, Portuguese, Russian, Spanish
Publisher review for EMS Data Import for SQL Server 3.6.0.1:
Review by: EMS Database Management Solutions, Inc
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
Requirements:
20MB of available HD space for program installation
Possibility to connect to any local or remote SQL Server
Microsoft Mouse or compatible pointing device
Microsoft Data Access Components (MDAC) or S
Operating system:
Windows 8, Windows 7, Windows Vista, Windows XP, Windows 2000, Windows 98
Limitations:
Expires in 30 days; Importing only 20 rows.
Release notes:
Major Update
Whats new in version 3.6.0.1:
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.
EMS Data Import for SQL Server screenshots:
EMS Data Import for SQL Server download tags:
sql server import import sql server data sql server import tool import data to sql server database import access to sql server import excel to sql server import csv to sql server import xls to sql server import xml to sql server mssql import
Copyright information:
SPONSORED LINKS
Based on 28 ratings. 28 user reviews.
DBDesigner 4
DB-MAIN
SQL-Front
Full Convert Enterprise
PC-Telephone
Liquid Desktop
Advanced Access Repair
ERD Concepts
Oraspeed SQL Editor
Accounting and Finance
Office Suites and Tools
Inventory and Barcoding
PIMS and Calendars
Databases and Tools
Project Management
Helpdesk and Remote PC
Calculators and Converters
Vertical Market Apps
Investment Tools
Math and Scientific Tools
Other
Timesheets MTS Software
Softvoile
NewFreeDownloads
Office Suites
PIMS
Math
Calculators
Helpdesk
Databases
Accounting
Inventory