Online Documentation for Data Import for SQL Server

Welcome to EMS Data Import utility!


EMS Data Import for SQL Server is a powerful program to import your data quickly from MS Excel, MS Word, MS Access, DBF, TXT, CSV, Open Document, HTML files to SQL Server 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.

 

Visit our web-site: http://www.sqlmanager.net/ for details.

 

 

Key features

  • Import from most popular formats: MS Excel, MS Access, XML, DBF, TXT, CSV, MS Word, Open Document Format and HTML
  • Importing data to one or several tables or views from different databases
  • Automatically creates table structure
  • 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
  • Command-line utility to import data using the configuration file
  • Powerful visual options module
  • User-friendly localizable wizard interface

 

Product information