In Excel, go to the Data section in the ribbon. Select Get Data and then from SQL Server. The dialog you get should be self-explanatory.
How to create Excel Connection to a SQL database
This connection must be validated by a SQL login to ensure the contents of your databases remain secure. The connection can be refreshed to update the content from the SQL database.
2 answers
Sort by: Most helpful
-
-
LucyChenMSFT-4874 4,675 Reputation points
2024-07-19T03:07:37.22+00:00 Hi @Jhon jr ,
Thank you for your reaching out and welcome to Microsoft Q&A!
Please refer to this link, it shows the steps in detailed.
To refresh the Excel Connection:
- Select the Data tab
- Select Refresh
Feel free to share your issues here if you have any concerns.
Best regards,
Lucy Chen
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.
https://docs.microsoft.com/en-us/answers/support/email-notifications