SQL Spreads 7.2.5 is now available for download. Fixed issue with the new Show intro button being shown in Data Editor mode. Download the latest version of SQL Spreads »
The Excel and SQL Server experts blog
SQL Spreads release 7.2.5
Johannes Åkesson - Nov 10, 2023SQL Spreads release 7.2.4
Johannes Åkesson - Nov 08, 2023SQL Spreads 7.2.4 is now available for download. Improved the Intro dialogs shown during the first start of the trial. Added a button in the SQL Spreads tab to show the Intro again. Minor bug fixes. Download the latest version of SQL Spreads »
Alternative to Microsoft Access: SQL Server + Excel
Andy McDonald - Oct 12, 2023In this article we’re going to look at why you might consider an alternative to a Microsoft Access database for your organization, or specific project. As we’ll see, Access has some limitations that can become a problem eventually. A simple solution is to use a combination of SQL Server and Excel, with the SQL Spreads …
SQL Spreads release 7.2.0
Johannes Åkesson - Aug 28, 2023SQL Spreads 7.2.0 is now available for download. Added a new intro dialog with info about the trial. Added a check if Excel is running before installation, and auto-restart of Excel after the installation. Added a lock to prevent a user with a Data Editor license to install and use the SQL Spreads trial in …
How to copy a table in SQL Server
Andy McDonald - Jul 18, 2023In this article we’re going to show you a quick and easy way to copy a table in SQL Server. The new Copy SQL Server Table feature in SQL Spreads means that you can copy a table from one database to another in just a few clicks from within Excel. Table of contents 1. Introduction …
SQL Spreads release 7.1.2
Johannes Åkesson - Jul 14, 2023SQL Spreads 7.1.2 is now available for download. In this new release we are introducing the new SQL Server tools which allows you to do more SQL Server operations from within Excel. The SQL Server tools contains these three features: The Table Creator – to create SQL Server tables based on data in Excel. The …
SQL Spreads: a front end for SQL Server
Andy McDonald - Jul 05, 2023There are several options available if you are looking for a front end for SQL Server. Like most things, what is best for you will depend on a number of factors. In this article, we’re going to look at the things to consider when choosing a front end for SQL Server and how the SQL …
Master Data Services Excel Add-in: What to Know and Alternatives
Andy McDonald - Jun 20, 2023In a previous article, we provided an overview of Master Data Management (MDM). In this article, we’re going to look at Microsoft’s platform for supporting the discipline of MDM: “Master Data Services”. Specifically, we’re going to look at how the Master Data Services Excel Add-in can be used to organize your MDM data models and …
SQL Spreads release 7.0.8
Johannes Åkesson - May 29, 2023SQL Spreads 7.0.8 is now available for download. This release fixed a couple of minor issues. Fixed issue with columns with data type Time not updating correctly. Fixed issue with Change tracking not working when only one of the ModifiedBy or ModifiedOn was used. Fixed issue with labels for number of loaded rows not shown …
Tree Filters in Excel: an easy way to view and filter SQL data
Andy McDonald - May 11, 2023With the rise of data democratization in the workplace, more people across the organization are working with datasets on a day-to-day basis. SQL Spreads makes this easier for people by letting them use Excel to update and manage data in SQL Server. One of the reasons people enjoy working in Excel is the familiarity of the UI …
