EMS Database Management Solutions announced new major version of EMS Data Import, a powerful tool to import your data quickly from MS Excel 97-2007, MS Access, DBF, XML, TXT, CSV, MS Word 2007, ODF and HTML files.
EMS Data Import for PostgreSQL is now available and can be downloaded from http://www.sqlmanager.net/products/postgresql/dataimport/download/
What’s new in Data Import for PostgreSQL version 3.0?
The new “Native” method of import is added which includes two algorithms – Single Commands and Batch Insert. Single Commands mode serves to generate and execute single SQL commands on the server; whereas Batch Insert uses COPY. With the help of Native mode your data can be imported dozen (!) times faster compared to Universal mode which was used in the previous versions.
Unicode support. Now you are able to import Unicode data.
Import from new formats is available now: MS Excel 2007, MS Word 2007, HTML, Generic XML, Open Document Format (Open Document Text and Open Document Spreadsheet) .
Now there is a short field type description next to field names that appear in different lists. This option is enabled by default. When necessary, it can be disabled from Tools>Preferences.
Utility source code significantly optimized, work speed increased.
Ability to import data from text files containing TAB symbols as a separator is added.
Other small improvements and bugfixes.
We hope you'll enjoy working with EMS products!
This post has been migrated from a previous version of the PostgreSQL website. We apologise for any formatting issues caused by the migration.