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.