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
LVL 1
ruanlab123Asked:
Who is Participating?
 
ruanlab123Connect With a Mentor Author Commented:
Found the problem, use the x64 postgres driver and then the connection works.
0
 
Dennis WallentinRetiredCommented:
Hi,

Would it be possible for You to provide us the connection string?
0
 
ruanlab123Author Commented:
No comments.
0
 
Dennis WallentinRetiredCommented:
Thanks for posting back. Please close this thread and no points should be given.

Kind regards,
Dennis
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.