• The Excel and SQL Server experts blog

  • How to Use SQL with Excel for Data Analysis

    Andy McDonald - Jun 08, 2022

    In a previous article, we talked about why most organizations should use both SQL Server and Excel for their data management needs. In this article, we’re going to look at an example of how to perform data analysis using SQL and Excel with an Excel Add-In, called SQL Spreads. You can use the Add-In to …

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

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

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

  • 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 1. Introduction 2. Excel: what are the disadvantages? 3. What is SQL? 4. Advantages of Using SQL 5. …

  • 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 1. Introduction 2. Option 1 : CSV to SQL using a SQL script 3. Option 2 : …

  • How to Update an SQL Table from Excel

    Johannes Åkesson - Nov 26, 2021

    SQL 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 use Excel to update SQL Server data

    Johannes - Oct 17, 2014

    End users love working in Excel; they know the tool and they are free to do what they want. That’s the heart of the much-loved Excel application, but also the start of problems for the people taking care of the data. The freedom to add cells and enter “whatever-you-like” values causes huge problems when trying …

  • Page 2 of 2«12