• SQL Spreads Blog

  • CSV to SQL: How to Convert, Open & Import

    May 12th, 2021

    Introduction Comma Separated Values (CSV) files are commonly used to exchange data from one system or application to another.  The simple format of the csv file makes them ideal for exporting data from one place and importing it to another.  A common use case, for example, is to export the data from an accounting or …

  • SQL Spreads release 6.0.17

    Mar 30th, 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

    Sep 30th, 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

    Jul 1st, 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 …

  • What’s new in SQL Spreads 5.0?

    May 7th, 2020

    SQL Spreads 5.0 is the largest update in over two years, with several new and exciting improvements. We have implemented a couple of long-anticipated features, such as: We have also implemented several changes to improve how you can develop and deploy SQL Spreads documents: To try SQL Spreads 5.0, you can download the 14-day free …

  • SQL Spreads release 5.0.55

    Apr 29th, 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 …

  • SQL Spreads release 4.50.148

    Dec 2nd, 2019

    SQL Spreads 4.50.148 is now available for download. Fixed issue with changing the SQL Server server name (the text field was disabled) when opening a document when the SQL Server instance is not accessible. Fixed issue with conflict detection not saving non-conflicting rows correctly. Fixed issue with checking the license on the server if a …

  • SQL Spreads release 4.50.139

    Oct 31st, 2019

    SQL Spreads 4.50.139 is now available for download. With this release, we are introducing a new license system that supports online activations and a lot of new features on the deployment and installation side. With the new online activations, there is no need to manually activate the licenses through emails. If you are an existing …

  • SQL Spreads release 4.4.7

    Jun 5th, 2019

    SQL Spreads 4.4.7 is now available for download. Fixed issue when working with protected Excel worksheets. Fixed issue with conflict detection giving an error under certain circumstances. Download the latest version of SQL Spreads »

  • How to import data from Excel to SQL Server using the SQL Spreads Excel Add-In

    May 8th, 2019

    In many businesses, the number-one choice to edit, analyze and store data is still Microsoft Excel. In this article, I will show you how a modern Excel Add-In can be used to collaborate and allow even non-technical users to import data from Excel to SQL Server in a simple, secure and structured way.

  • Page 2 of 6«12345»...Last »
Envelope Iconsmall picture of an envelope signifying email Need help?