EMS Data Import for SQL Server 3.3

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

Keywords: 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

Author:

EMS Database Management Solutions, Inc     Other programs by EMS Database Management Solutions, Inc

Downloads:

510

Size:

6548K

Cost:

$95.00 US

Users Rating:

    Reviews (0)     Write review

Feedback:

Report broken download     Report spyware [?]

License:

Shareware [?]

Operating Systems:

Release Status:

update (2010-02-18)

Recent Changes:

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.

Supported Languages:

English, French, German, Italian, Portuguese, Russian, Spanish

Additional Requirements:

Pentium 300; 32 MB RAM; Possibility to connect to some local or remote Microsoft SQL Server

XlsToSql
XlsToSql - Import Excel to SQL Server easy and quickly.

EMS SQL Management Studio for SQL Server
A complete solution for SQL Server administration and database development

EMS SQL Manager for SQL Server
Powerful graphical tool for SQL Server administration and development.

TxtToSql
TxtToSql - Import CSV (TSV,TXT) to SQL Server easy and quickly.

AccessToMsSql
AccessToMsSql - Import Access to SQL Server easy and quickly.

Exportizer Pro
Database export tool

Altova MapForce Enterprise Edition
Altova MapForce is a graphical data mapping, integration, and ETL tool.

Advanced ETL Processor 32 Bit
Extract, transform, validate and load data into ANY database

Database Tour
Universal database tool

Database Browser Portable
This Easy to use tool allows user to connect to any database and browse it.

Altova MapForce Professional Edition
Altova DatabaseSpy Enterprise Edition
TextPipe Pro
Events Management Software
dbForge Data Compare for MySQL
dbForge Query Builder for MySQL
dbForge Schema Compare for MySQL
RazorSQL
Visual Importer ETL Enterprise 32 Bit
Database Browser Portable

Database Tour Pro (1537 dl.)
Altova DatabaseSpy Enterprise Edition (1448 dl.)
Exportizer (1434 dl.)
Visual Importer ETL Standard 32 Bit (1410 dl.)
RazorSQL (1400 dl.)
Altova MapForce Professional Edition (1356 dl.)
Advanced ETL Processor Professional 32 Bit (1327 dl.)
Advanced ETL Processor Enterprise 32 Bit (1320 dl.)
DTM Data Generator (1268 dl.)
Visual Importer ETL Enterprise 32 Bit (1246 dl.)