How to create Excel Connection to a SQL database

Jhon jr 0 Reputation points
2024-07-18T20:11:35.03+00:00

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,345 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Erland Sommarskog 107K Reputation points
    2024-07-18T20:54:26.69+00:00

    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.

    0 comments No comments

  2. LucyChenMSFT-4874 2,995 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.

    User's image

    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