How to connect aws postgresql with microsoft excel?

Sagar Kumar 0

Hi,

I am using MS Office Home, and I am trying to connect my AWS PostgreSQL DB with my Excel locally as well as on OneDrive, but I couldn't find any option to set up a connection. Can you please help me with this?

1 answer

Emi Zhang-MSFT 22,011 Reputation points Microsoft Vendor

2024-04-29T01:39:40.3266667+00:00

Hi,

What version of Office did you use?

Do you have Power Query in Excel?

I suggest you go to Data- Get data- From Database- From PostgreSQL Database:

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
Sagar Kumar 0 Reputation points

2024-04-29T08:47:51.46+00:00

Hi,

As I am using Microsoft 365, on which only From SQL Server Database to SQL Server Analysis Service Database is showing. Unable to see the Postgresql Database option on my excel.

Emi Zhang-MSFT 22,011 Reputation points Microsoft Vendor

2024-04-30T02:25:17.88+00:00

If your version can't use From PostgreSQL Database directly, you can refer to the link below and try using the DOBC driver to link to it.

https://stackoverflow.com/questions/48847987/connect-excel-to-postgresql-via-odbc

https://stackoverflow.com/questions/47591360/installing-postgresql-odbc-driver-on-windows-10

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.
Sign in to comment