SQL Spreads 7.5.6 is now available for download. Resolved an issue with the new setting for lookups, enabling the creation of dependent drop-down lists. Download the latest version of SQL Spreads »
The Excel and SQL Server experts blog
-
SQL Spreads release 7.5.5
Johannes Åkesson - Sep 17, 2024 -
SQL Spreads release 7.5.5
Johannes Åkesson - Sep 13, 2024SQL Spreads 7.5.5 is now available for download. Fixed issue with connecting to Azure using Azure AD Authentication Download the latest version of SQL Spreads »
-
SQL Spreads release 7.5.4
Johannes Åkesson - Sep 03, 2024We’re excited to announce the release of SQL Spreads 7.5.4, which focuses on improving the Tree Filters and Intro dialogs, as well as addressing various bug fixes. New Features and Enhancements Redesigned Introductory Dialogues: We have redesigned the introductory dialogues to provide a more intuitive user experience. This includes a new option to restart the …
-
Power BI Dashboards: Examples & Use Cases
Andy McDonald - Aug 30, 2024Power BI is a Business Intelligence (BI) platform. With Power BI, users can get data, analyze it, and create visualizations that help turn data into actionable information for their business. In this article, we’re going to look at creating Power BI dashboards and reports, and give some examples of how and when to use them. …
-
How to Update an SQL Table from Excel
Johannes Åkesson - Aug 06, 2024SQL Spreads solves some common data management problems for Microsoft SQL Server. It makes it fast and simple to update an SQL table from an Excel spreadsheet. And it gives you the control you need to manage data entered by various users on a collaborative team. End users love working in Excel End users love …
-
How to perform an INSERT in SQL Server
Johannes Åkesson - Aug 01, 2024Inserting data into SQL Server is a fundamental operation for business users who need to add new records to their databases. This guide will walk you through the process of using the INSERT statement in SQL Server, providing comprehensive steps and code snippets you can use directly in SQL Server Management Studio (SSMS). Understanding the …
-
How to perform a DELETE in SQL Server
Johannes Åkesson - Aug 01, 2024Deleting data in SQL Server is a critical operation for business users who need to remove obsolete or incorrect records from their databases. This guide will walk you through the process of using the DELETE statement in SQL Server, providing comprehensive steps and code snippets you can use directly in SQL Server Management Studio (SSMS). …
-
How to create a database in Excel
Johannes Åkesson - Aug 01, 2024Creating a database in Excel is a straightforward process that can help you manage and analyze your data efficiently. Whether you need to keep track of personal information, business records, or project details, Excel offers powerful tools to build and maintain a database. Follow these steps to create a database in Excel: 5 steps on …
-
How to perform a SELECT INTO in SQL Server
Johannes Åkesson - Aug 01, 2024The SELECT INTO statement in SQL Server is a powerful tool for creating new tables and copying data from existing tables or queries. This guide will walk you through the process of using the SELECT INTO statement in SQL Server, providing comprehensive steps and code snippets you can use directly in SQL Server Management Studio …
-
How to perform an UPDATE in SQL Server
Johannes Åkesson - Jun 28, 2024Updating data in SQL Server is a common task for business users who need to ensure their data remains accurate and up-to-date. This guide will walk you through the process of using the ‘UPDATE’ statement in SQL Server, providing easy-to-follow steps and code snippets you can use directly in SQL Server Management Studio (SSMS). Understanding …
Product
Key features
Use Cases
Compare SQL Spreads
Resources
Doc
Support
Company
Subscribe for updates
×