• The Excel and SQL Server experts blog

  • SQL Spreads release 6.2.8

    Johannes Åkesson - Aug 09, 2022

    SQL Spreads 6.2.8 is now available for download. Fixed issue with bigint numbers with more than 17 digits that were truncated. Fixed issue with commas in text key columns. Fixed issue with uninstalling when both the per-machine and the per-user versions was installed. Fixed issue with the database connection setting “Remember password on local machine”. …

  • SQL Spreads release 6.2.1

    Johannes Åkesson - May 23, 2022

    SQL Spreads 6.2.1 is now available for download. Support for connecting to Azure SQL using Azure AD Authentication. Support for using Multi-Factor Authentication when authenticating to Azure AD. Download the latest version of SQL Spreads »

  • SQL Spreads release 6.1.32

    Johannes Åkesson - Mar 29, 2022

    SQL Spreads 6.1.32 is now available for download. Improved deleting of rows in the database to align with Excel’s Delete rows. Added check if per-machine or per-user installer exists. Added a possibility to call Excel’s Refresh All command after data is saved to the database. Fixed bug so that commas can be used in Pivot …

  • SQL Spreads release 6.1.15

    Johannes Åkesson - Dec 09, 2021

    SQL Spreads 6.1.15 is now available for download. Added support for the new pricing model with Basic, Pro and Premium plans and separate Editor licenses. Added a checkbox to the Table Creator to decide if columns in a new table should be nullable. Added a field to set the name of the Identity column in …

  • SQL Spreads release 6.0.44

    Johannes Åkesson - Oct 29, 2021

    SQL Spreads 6.0.44 is now available for download. This new release focus on stability improvements – we have made a number of stability improvements and fixes in the areas around Excel table formatting, detection of changes in SQL Server etc. Added the possibility to set a Default value for a column to use when a …

  • SQL Spreads release 6.0.30

    Johannes Åkesson - Jun 17, 2021

    SQL Spreads 6.0.30 is now available for download. This new release introduce a new feature to use the Tree filter selection as the key column when inserting new rows into a table. Added a new Parameter selection dialog to easily insert Tree Filter and Cell parameters. Added the possibility to remove key columns that are …

  • SQL Spreads release 6.0.17

    Johannes Åkesson - Mar 30, 2021

    SQL Spreads 6.0.17 is now available for download. SQL Spreads 6.0 introduces the new Lookup feature to easily lookup key values from a related table or a list of fixed key-text pairs. A drop-down list in Excel allows the user to select a text item, while the corresponding key will be written to the database. …

  • SQL Spreads release 5.1.12

    Johannes Åkesson - Sep 30, 2020

    SQL Spreads 5.1.12 is now available for download. Added support for using key columns with the UNIQUE IDENTIFIER data type while also generating new IDs as a default value in SQL Server. Fixed issue with Designer being locked for new worksheets in certain cases. Minor bug fixes Download the latest version of SQL Spreads »

  • SQL Spreads release 5.1.07

    Johannes Åkesson - Jul 01, 2020

    SQL Spreads 5.1.07 is now available for download. The Excel table is now always resized to the number rows that are imported from the database. Added support for using SQL Server columns with the data type DateTimeOffset. Conflict detection will now work over different time zones when setting the ModifiedOn Change Tracking column to a …

  • SQL Spreads release 5.0.55

    Johannes Åkesson - Apr 29, 2020

    SQL Spreads 5.0.55 is now available for download. SQL Spreads 5.0 is the largest SQL Spreads update in over two years with several long-wished features and improvements such as data pivoting, the table creator and database, and table search. Introducing the new Pivoting feature to update pivoted data in columns in Excel into rows in …

  • Page 1 of 512345»