In order to be able to connect Access, Excel, etc. to the IMSMANG database and/or the staging area database PostgreSQL ODBC driver needs to be installed on the computer that will connect to the database(s).
 |
The PostgreSQL used with IMSMA is 32 bits version but it depends on Microsoft Office version if it is 32 bits PostgreSQL ODBC driver or 64 bits PostgreSQL ODBC driver that should be installed. If you have 32-bits Microsoft Office installed, you should install the 32-bits driver and if you have 64-bits Microsoft Office, you should install the 64-bits driver. |
- Download the one of drivers from here.
- Unzip the installation package
- Start the installation with administrator permission
Click Next
Accept and click Next
Click Next
Click Install
Click Finish
Next step is to create an ODBC source to the IMSMANG database and/or the staging area database.