Filling Linux databases from Windows
Trying to fill Linux databases like MySQL and PostgreSQL is a hard task. A search day in google, cuil and yahoo found nothing useful, but a bunch of scripts, uncomplete tools or licensed software.
A workaround of such situation is to use the ODBC drivers on Windows, pointing towards the Linux databases. Obviously, the ODBC drivers of the database must be available in the system.
From Access/Windows to PostgreSQL/Linux:
1. Install the PostgreSQL ODBC drivers in Windows
2. Configure a System DSN with the PostgreSQL driver pointing toward your PostgreSQL DBMS on Linux.
3. Run Access and right-click on a data-table, voila… export to ODBC data source.
The PostgreSQL must be configured and running properly in Linux.
Access has many data-importer filters/wizards and ODBC compatibility, so if your Windows DBMS can’t connect/export with/to Linux DBMS a workaround is the usage of Access as a bridge.