14,494 questions
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 54%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJJ%3C/text%3E%3C/svg%3E)
Jhon jr
0
Reputation points
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 Other
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2024-07-22T06:21:46.5933333+00:00 Hi @Jhon jr ,
We haven't heard any response from you yet.
Is this issue solved now? If you have any questions, please feel free to share with us.
May I humbly suggest that you accept Answer if they helped. It may help others who see the thread in seek of help.
Your action would be helpful to other users who encounter the same issue and read this thread. :)
Thanks for your understanding. Wish you have a nice day!
Best regards,
Lucy Chen
-
Anonymous
2024-07-25T02:20:56.9766667+00:00 Hi @Jhon jr ,
Could you please tell us if there is any new progress on this issue?
We are still very concerned about your issue!
In addition, I don't want to nag you, but maybe the answers are helpful. May I humbly suggest that please accept Answer if they helped.
Your action would be helpful to other users who encounter the same issue and read this thread.
The links and methods we provide will also help them resolve their issue or follow up this issue with us together!
Thanks for your understanding. Your encouragement and recognition are the driving force for our progress!
Best regards,
Lucy Chen
-
Anonymous
2024-08-02T05:51:45.81+00:00 Hi @Jhon jr ,
Could you please tell us if there is any new progress on this issue?
We are still very concerned about your issue!
In addition, I don't want to nag you, but maybe our answers are helpful. May I humbly suggest that please accept Answer if they helped.
Your action would be helpful to other users who encounter the same issue and read this thread.
The links and methods we provide will also help them resolve their issue or follow up this issue with us together!
Thanks for your understanding. Your encouragement and recognition are the driving force for our progress!
Best regards,
Lucy Chen
Sign in to comment
2 answers
Sort by: Most helpful
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator2024-07-18T20:54:26.69+00:00 -
Anonymous
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
-
Anonymous
2024-07-23T02:32:09.3066667+00:00 Hi @Jhon jr ,
We haven't heard any response from you yet.
Could you please let us know how your issue regarding How to create Excel Connection to a SQL database is going?
Is this issue solved now? If you have any questions, please feel free to share with us.
May I humbly suggest that you accept Answer if they helped. It may help others who see the thread in seek of help.
Your action would be helpful to other users who encounter the same issue and read this thread. :)
Thanks for your understanding. Wish you have a nice day!
Best regards,
Lucy Chen
-
Anonymous
2024-07-24T08:20:55.21+00:00 Hi @Jhon jr ,
Could you please let us know how your issue regarding Issue with SQL Server compatibility level 2022 and sp_executesql is going?
If you have any concerns, please feel free to share your issues here, we will offer you more support.
If the answer has successfully resolved your problem, to smoothly close this thread, please don't forget to 'Accept it'. This will greatly encourage our work and help others who have similar issues!
Thanks for your understanding!
Best regards,
Lucy Chen
-
Anonymous
2024-07-26T05:35:11.9533333+00:00 Hi @Jhon jr ,
Could you please tell us if there is any new progress on this issue?
We are still very concerned about your issue!
In addition, I don't want to nag you, but maybe our answers are helpful. May I humbly suggest that please accept Answer if they helped.
Your action would be helpful to other users who encounter the same issue and read this thread.
The links and methods we provide will also help them resolve their issue or follow up this issue with us together!
Thanks for your understanding. Your encouragement and recognition are the driving force for our progress!
Best regards,
Lucy Chen
-
Anonymous
2024-07-30T08:48:18.9266667+00:00 Hi @Jhon jr ,
Could you please tell us if there is any new progress on this issue?
We are still very concerned about your issue!
In addition, I don't want to nag you, but maybe the answers are helpful. May I humbly suggest that please accept Answer if they helped.
Your action would be helpful to other users who encounter the same issue and read this thread.
The links and methods we provide will also help them resolve their issue or follow up this issue with us together!
Thanks for your understanding. Your encouragement and recognition are the driving force for our progress!
Best regards,
Lucy Chen
Sign in to comment