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 »
The Excel and SQL Server experts blog
-
SQL Spreads release 6.2.1
Johannes Åkesson - May 23, 2022 -
How to Connect Power Apps to SQL Server
Andy McDonald - May 13, 2022In this article, we’re going to look at how to connect Power Apps to SQL Server. This provides a slightly deeper dive than was covered in our previous Quick Start Guide to Power Apps. Power Apps is the low-code/no-code platform from Microsoft. It aims to make it quick and easy for people in organizations to …
-
SQL Server Import and Export Wizard Guide
Andy McDonald - May 06, 2022This guide explains how to use the SQL Server Import and Export Wizard to get data into a SQL Server database. What is the SQL Server Import and Export Wizard? SQL Server Import and Export Wizard is a simple way to copy data from a source to a destination. It is most commonly used to …
-
Connect Excel to SQL Server: 3 Easy Steps
Andy McDonald - May 06, 2022In a previous article, we spoke about why you need both Excel and SQL in your data management solutions, but how do you connect Excel to SQL Server? In this article, we’re going to show you the steps and highlight a key benefit of using an Excel add-in like SQL Spreads. But, first, we’re going …
-
Export Power BI to Excel: Solved
Andy McDonald - May 03, 2022Power BI is a Business Intelligence (BI) platform. With Power BI, users can get data, analyze it, and create visualizations that help turn raw data into actionable information for their business. It’s normally the case that you want to import data from Excel to Power BI to create a dashboard or report, but there are …
-
Connect Power BI to SQL Server: Step-by-step Guide
Andy McDonald - Apr 23, 2022Power BI is a great way to visualize your data. In previous articles, we’ve introduced Power BI dashboards and gone through a step-by-step example to create a Power BI report using data from SQL and Excel. In this article, we’re going to look in more detail at the process for how to connect Power BI …
-
Power BI Fact and Dimension Tables
Andy McDonald - Apr 01, 2022In an earlier article, we looked at how to create a dashboard based on some sales data. The data source for that example was several tables in a SQL database. In this article, we’re going to look in more detail at the data model we built in that Power BI example, and specifically the use …
-
SQL Spreads release 6.1.32
Johannes Åkesson - Mar 29, 2022SQL 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 …
-
Power BI write back to SQL Database: 2 methods
Andy McDonald - Mar 12, 2022Power BI dashboards and reports are often created using a SQL database as a data source. In this article, we’re going to discuss 2 methods on how to write back to SQL from Power BI. Power BI write-back to SQL: Use cases We all use dashboards and reports on a regular basis to help give …
-
SQL and Excel: Why you need both
Andy McDonald - Mar 12, 2022SQL vs. Excel: which is better? As you can see from the title of this article, it’s not the case that you should choose one over the other; you actually need SQL and Excel. Introduction Excel is a really great application. There are not many applications that are used by such a wide variety of …
Product
Key features
Use Cases
Compare SQL Spreads
Resources
Doc
Support
Company
Subscribe for updates
×
×