• The Excel and SQL Server experts blog

  • 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 - Mar 12, 2022

    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 • …

  • How to use XLOOKUP: Guide and Examples

    Andy McDonald - Mar 02, 2022

    If you’ve been using Excel for a while, you’ll undoubtedly have used one of its most useful functions – VLOOKUP.  This lookup function is invaluable when manipulating data or preparing reports in Excel.  If you’re already familiar with VLOOKUP, then you’ll love the new XLOOKUP function that Microsoft released in late 2019.  It overcomes some …

  • What is Power Apps? Quick Start Guide

    Andy McDonald - Feb 18, 2022

    More and more people are using no-code technologies to create mobile apps, and there are a growing number of vendors in this area.  In this article, we’ll be focusing on Microsoft’s no-code platform, Power Apps. Because it’s a no-code platform it should be easy to create apps, right?! Well, yes, it is easy to use …

  • Creating Reports with Power BI, SQL and Excel

    Andy McDonald - Feb 09, 2022

    In an earlier post, we introduced Power BI and looked at what makes a good dashboard.  In this article, we’re going to go through the steps for creating reports with Power BI, SQL, and Excel.   Table of contents • How Does Power BI Work? A Brief Overview • Step-by-Step Example: Create a Report in …

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

    Andy McDonald - Jan 31, 2022

    In this article, we’re going to look at 3 ways to convert a CSV file to SQL. This is a common use case, so hopefully, you’ll find the following information useful in your day-to-day work. Table of contents • Introduction • Option 1 : CSV to SQL using a SQL script • Option 2 : …

  • Power BI Dashboards: Examples & Use Cases

    Andy McDonald - Jan 21, 2022

    Power 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. …

  • SQL Spreads release 6.1.15

    Johannes Åkesson - Dec 09, 2021

    SQL Spreads 6.1.15 is now available for download. Added support for the new pricing model with Basic, Pro and Premium plans and separate Editor licenses. Added a checkbox to the Table Creator to decide if columns in a new table should be nullable. Added a field to set the name of the Identity column in …

  • Page 3 of 8«12345»...Last »