Excel

Connect a SQL Server database to your workbook

Leave a comment

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:

https://support.office.com/en-us/article/Connect-a-SQL-Server-database-to-your-workbook-22C39D8D-5B60-4D7E-9D4B-CE6680D43BAD

 

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

http://www.sqlsaturday.com/592/eventhome.aspx

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