Intro to the SQL Server Tools feature
    • Dark
      Light
    • PDF

    Intro to the SQL Server Tools feature

    • Dark
      Light
    • PDF

    Article summary

    The SQL Server Tools feature extends some of the capabilities of SQL Server Management Studio into Excel through the SQL Spreads Add-In.

    With SQL Server Tools, SQL Spreads Designers can from within Excel:

    • Create new SQL Server tables based on data in Excel
    • Add, Delete and Modify columns in existing SQL Server tables
    • Copy tables from one database to another

    You'll find the SQL Server Tools menu button on the SQL Spreads ribbon.

    SQLServerTools_RibbonMenuButton2.png

    The following sections explain how to use the tools.


    Was this article helpful?