• The Excel and SQL Server experts blog
  • Introducing the new Table Wizard

    Johannes - Sep 08, 2014

    We are proud to announce the release of SQL Spreads 2014 with the completely new Table Wizard. The Table Wizard makes it extremely simple to create an Excel document which can be used to Update, Insert or Delete data in a SQL Server table.

    The Wizard contains five screen:

    • First select your Database and and Table
    • Second, select the Worksheet and Cell where the table data should be inserted
    • Third select which columns in the table to include
    • Fourth, set up Texts to show as Drop Down Lists in Excel for foreign key columns
    • Lastly do a few settings and then click Finish

    When clicking Finish, SQL Spreads will load the data from SQL Server into Excel.

    You now have an Excel document ready to share with others to let them Update, Insert or Delete data in SQL Server direclty from Excel.

    After running the Wizard you can configure every detail of importing and exporting data between SQL Server and Excel. The Wizard will automatically create and configure the following elements in the Excel document:

    • An import of table data from SQL Server into the selected worksheet in Excel
    • A mapping between the columns in Excel to the Fields in the table in SQL Server
    • For any detected Foreign Key relation in the table, the Wizard will setup Integrity Checks with Drop Down Lists in the columns Excel

    Comments (3)

    Jose Barahona » 15. Apr, 2015

    I have a problem when I import a table without identity column. The table itself has 2 primary keys but no identity because it is a SAP database in MSSQL. Maybe you have the answer to my question?

    By the way it’s a good application.

    Greetings from El Salvador.

Use Excel to update your data in SQL Server?

Try the SQL Spreads data management solution to update and manage your SQL Server data from within Excel.