Connect a SQL Server database to your workbook

Last week I shared the ODBC connection method for connecting SQL Server data to Excel.  Now that you’ve mastered the intricacies of that technique, I want to share a simpler method.

You can use the Data Connection Wizard to create a dynamic connection between a SQL Server database and your Excel workbook.

This type of connection is read-only  —  you cannot update any data in the database from your workbook.

Here is a link to the article:


I will be attending PASS SQL Saturday on March 11 – I HOPE TO SEE YOU THERE ! !

It will be a mind-blowing event that should not be missed . . .





Leave a Reply

Your email address will not be published. Required fields are marked *