Download the Windows 32-Bit drivers from www.postgresql.org

Download link: The version required is psqlodbc_09_00_0310.zip

From the windows desktop go to Start -> Run (or Win+R to open the Run dialog)

Enter the following command to open the 32-bit ODBC Administrator

C:\Windows\SysWOW64\odbcad32.exe

You should now see this dialog. Make sure the System DSN tab is selected and click Add...

Select the PostgreSQL ANSI driver and click Finish.

You should see the following:

Enter the details as follows:

Ensure that you press Test to make sure your connection is valid

Click Save.

In this example we are using Access 2013. Select External Data > ODBC Database

Select 'Link to the data source by creating a linked table'

Select Machine Data Source and the name of the Data Source Name you have created.

In this example we wish to inspect the table used by the Logger application which is public.at_incidents.

Browser not supported