• SQL Spreads Blog

  • How to Connect Power Apps to SQL Server

    Andy McDonald - May 13, 2022

    In 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, 2022

    This guide explains how to use the SQL Server Import and Export Wizard to get data into a SQL Server database. Table of contents 1. What is the SQL Server Import and Export Wizard? 2. What data sources and destinations can be used? a. Some example scenarios 3. How to use the SQL Server Import …

  • Connect Excel to SQL Server: 3 Easy Steps

    Andy McDonald -

    In 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, 2022

    Power 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, 2022

    Power 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, 2022

    In 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, 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 …

  • How to insert data from Excel to SQL Server

    Johannes Åkesson - Mar 21, 2022

    Most people do not know that there is a really simple way to copy and paste data from Excel to SQL Server. In this article, I will show you what you need to know to copy and paste data from Excel to SQL Server.
    I will go through and show the technique using simple step-by-step instructions, and I will also cover a few special cases that are great to know.

  • Power BI write back to SQL Database: 2 methods

    Andy McDonald - Mar 12, 2022

    Power 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. Table of contents • Power BI write-back to SQL: Use cases • Power BI write-back to SQL using Power Apps …

  • SQL and Excel: Why you need both

    Andy McDonald -

    SQL 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. Table of contents • Introduction • Excel: what are the disadvantages? • What is SQL? • Advantages of Using SQL • …

  • Page 1 of 712345»...Last »
Envelope Iconsmall picture of an envelope signifying email Need help?