• The Excel and SQL Server experts blog
  • SQL Spreads release 3.1.0

    Johannes Åkesson - Aug 13, 2015

    SQL Spreads 3.1.0 is now available for download. The new release includes support to manage data in SQL Server tables that does not have any identity key.

    Wizard - Select Column

    • The major change in 3.1 is the ability to use a combination of key columns in a table. This removes the previous requirement for an Identity column in the table.
    • Added improved database selection without the need for the ‘View any definition’ permission.
    • Added automatic detection of key columns based on primary key or identity column.
    • Added Feedback dialog.
    • Added new ‘Document Settings’: “Refresh Import Data after save to database”. If this new setting is enabled, the spreadsheet data from SQL Server will be automatically refresh immediately after changes are submitted to the database.
    • Improved the screen for selecting 32- or 64-bit Excel when installing for Office 365.
    • Fixed issue with Execute button in Setup Filter dialog when using the @WindowsUser parameter in the SQL Query.
    • Fixed issue when exporting a fixed number of rows.
    • Fixed issue when mapping an Import filter to a Primary Key column in the database.

    Download the latest version of SQL Spreads »

    Comments are closed.

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.