ruanlab123
asked on
Connecting to Postgres DB with Excel
Hi
I want to create a data connection from excel to Postgres by using ODBC. I'm using ODBC for my application to connect to postgres and the ODBC is working fine, but thru excel the following error occur - Operation cannot be executed because an error occurred during connection to the driver, error also attached.
I'm using Microsoft Office Professional Plus 2010 and Postgres 8.2.4.1, with ODBC driver version 7.03.01.00 from Insight Distribution Systems . If somebody can please help me for just connecting to postgres from excel.
Thanks
Excel-Error-Postgres-ODBC.png
I want to create a data connection from excel to Postgres by using ODBC. I'm using ODBC for my application to connect to postgres and the ODBC is working fine, but thru excel the following error occur - Operation cannot be executed because an error occurred during connection to the driver, error also attached.
I'm using Microsoft Office Professional Plus 2010 and Postgres 8.2.4.1, with ODBC driver version 7.03.01.00 from Insight Distribution Systems . If somebody can please help me for just connecting to postgres from excel.
Thanks
Excel-Error-Postgres-ODBC.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
No comments.
Thanks for posting back. Please close this thread and no points should be given.
Kind regards,
Dennis
Kind regards,
Dennis
Would it be possible for You to provide us the connection string?