EMS Data Import for PostgreSQL

EMS Data Import for PostgreSQL is a powerful tool to import your data quickly from MS Excel, MS Access, DBF, XML, TXT and CSV files to PostgreSQL tables.

Features: It is necessary quite often to import large amounts of data into existing databases for maintenance purposes. The data import for PostgreSQL is able to do the import from a variety of sources in a range of formats.EMS Data Import supports almost all widespread formats of the source files. Thus there is no need for any preliminary conversions. Text files, spreadsheets, local databases, information from web pages are all supported. data from DBMS servers such as SQL Server, ORACLE, MySQL, PostgreSQL, InterBase/Firebird, DB2 etc are possible. Import from 10 most popular formats MS Excel 97-2007, MS Access, XML, DBF, TXT, CSV, MS Word 2007, OpenDocument Format and HTML are available. As the application uses native access to the server, it ensures maximum productivity during import process and reduces the time required to import a large amount of information.

EMS Data Import offers a variety of possible settings for the import parameters like import mode, possible transformation of data types during import process, skipping the unnecessary information and many others. All settings can then be saved into a configuration file for future use. The program’s interface is wizard based and is simple to use. The console version of the utility simplifies and automates typical import tasks by calling the program on schedule and with predetermined settings. A number of import modes are possible that include insert all, insert new, insert or update and more. You can save current wizard session parameters for future use.

Overall: A nice and handy tool for data import into Postgre SQL databases.

EMS Data Import for PostgreSQL is a powerful tool to import your data quickly from MS Excel, MS Access, DBF, XML, TXT and CSV files to PostgreSQL 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 PostgreSQL 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