This 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 …
The Excel and SQL Server experts blog
-
SQL Server Import and Export Wizard Guide
Andy McDonald - May 06, 2022 -
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 …
-
How to use XLOOKUP: Guide and Examples
Andy McDonald - Mar 02, 2022If 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, 2022More 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 …
