Connecting to Local SQL Instance from Excel

  1. Open excel
  2. Select from the drop down menu Data > Import External Data > Import Data
  3. In the "Select Data Source" Dialog, double click "Connect to a New Data Source"
  4. In the "Data Connection Wizard", select "Micrsoft SQL Server"
  5. Click Next
  6. Enter ".\PROVIDUSSTD" for the server name
  7. Leave Windows Authentication selected (although you could use "sa" and "velocityscape" as well)
  8. Click Next
  9. Select the database you want from the drop down
  10. Select the table you want
  11. Click Next
  12. Fill in information to save this connection as you want
  13. Click Finish
  14. 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.