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.
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 ! !
http://www.sqlsaturday.com/592/eventhome.aspx
It will be a mind-blowing event that should not be missed . . .