Connecting to Local SQL Instance from Excel

#Open excel
#Select from the drop down menu Data > Import External Data > Import Data
#In the "Select Data Source" Dialog, double click "Connect to a New Data Source"
#In the "Data Connection Wizard", select "Micrsoft SQL Server"
#Click Next
#Enter ".\PROVIDUSSTD" for the server name
#Leave Windows Authentication selected (although you could use "sa" and "velocityscape" as well)
#Click Next
#Select the database you want from the drop down
#Select the table you want
#Click Next
#Fill in information to save this connection as you want
#Click Finish
#In the "Import Data" window, just click "OK"

Your table, as it currently is displayed in the database, should not be displayed.

You can update the contents of this table by selecting Data > Refresh Data from the drop down menu at any time.

Web Scraper and Web Macros FAQs

Navigation

Connecting to Local SQL Instance from Excel