How to connect aws postgresql with microsoft excel?

Question

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

Your answer

Answer 1

Emi Zhang-MSFT 30,046 Microsoft External Staff

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:

User's image

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.

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 30,046 Reputation points Microsoft External Staff

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.

Share via

How to connect aws postgresql with microsoft excel?

1 answer

Your answer