Editor's review
This is a tool that can help with transfer of Excel data to PostgreSQL database.
XlsToPG is a data conversion tool that helps import of Excel data to PostgreSQL database. This is a utility for the Windows platforms including Windows 2000, XP, 2003, Vista, 2008, 7, and 8. Configuring the transfer through the interface is simple. You could easily select the source fields and destination fields by simply clicking the terms. Specific schema and table to be selected can be specified easily. Type of transfer can be set easily too. It may be replacement of existing data and filling-in of fresh data, etc. The progress bar provides you useful feedback about the transfer. Not only do you get visual indication of the transfer status, you get a percentage indication as well as actual number of records transferred. Log details provide you with indications if everything went fine. It will give you some indication as to the cause of a problem if that does happen.
The interface is simple and should not pose a problem to anyone, particularly not with the IT and DBA types who are going to use this tool. A wizard is available to make things easy when you get started. Saving of session parameters and the ability to load them again for a different session makes transfers easy. When you have transfers on a regular basis, this feature helps immensely. With Unicode support, this tool is able to handle data in most languages of the world. Users who have become experienced with the tool will be able to derive productivity gains through the use of the command line interface provided. A task scheduler available can make routine transfers automatic. This is a handy tool and is quite good.
User comments