MS Access

Microsoft Access is a popular data management application that allows you to store information in tables that it manages directly from the local disk. It has many built in features to assist you in constructing and viewing your information. You can find more information at http://www.microsoft.com/office/access.

PostgreSQL

PostgreSQL is a highly scalable, SQL compliant, open source object-relational database management system. With more than 15 years of development history, it is quickly becoming the de facto database for enterprise level open source solutions. Further information at  http://www.postgresql.org.

PostgreSQL Dump

PostgreSQL Dump is a text file containing all necessary SQL queries that must be sent to database server. When imported to a non-filled PostgreSQL database SQL statements build \ rebuild the structure, then populate that structure with the data. Such functionality is used not only when you would like to create a database wholly and fill it with data. Saving into MySQL Dump can be also very useful when you want to add data to an existing PostgreSQL database.

You can import PostgreSQL Dump into existing PostgreSQL database as follows:
psql -h hostname -U username -d {PostgreSQL database name} < {dump file name}

For more details refer to your PostgreSQL documentation.

Ability to store data into a dump file is the best way to present deferred conversion and gain more control over the conversion process. The program fixes the contents of the source database into a local dump file instead of sending it to PostgreSQL server directly. The destination file will consist of statements to create all tables and to fill them with the data. Using this dump file PostgreSQL server administrator will add data to your PostgreSQL base.

PostgreSQL Php (Php script)

PHP script allows you to upload all necessary data to PostgreSQL server.

In case you have got no access to a PostgreSQL database there is an opportunity for you to save your data into PHP Script file. This will allow you to add data to your PostgreSQL database with no direct access to it. Having put your data in MS Access you can find out that it is not possible to update the data in PostgreSQL base as you have no access to it. To gain access to a PostgreSQL base you usually need to obtain the permission for connection from the particular IP address. It's not always possible to get an access even possessing log-in name and password. Database administrator can deny your access being concerned in protecting the information and avoiding insecure connections.
In case you face such a problem just save data of a MS Access database in PHP script. This file will be copied to the server where work with particular PostgreSQL database is executed. IP address of the server is already defined. The file can be launched from any place connected to Internet and the contained data will be added to the database. The speed of data export is much faster as if MS Access databases would be copied to PostgreSQL database directly because of the fact that the copying to PostgreSQL database is executed with utilization of the server where the particular script is launched.