• SQL Spreads Blog

  • SQL and Excel: Why you need both

    Jun 17th, 2021

    Introduction 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. Excel is a really great application.  There are not many applications that are used by such a wide variety of …

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

    May 12th, 2021

    Introduction Option 1 : CSV to SQL using a SQL script The SQL script to import CSV to SQL is quite straightforward.  It simply involves creating a table and then performing an insert of the data.  But, as you’ll soon see, whilst this is fine for a small dataset, if you need to import lots …

  • How to import data from Excel to SQL Server using the SQL Spreads Excel Add-In

    May 8th, 2019

    In many businesses, the number-one choice to edit, analyze and store data is still Microsoft Excel. In this article, I will show you how a modern Excel Add-In can be used to collaborate and allow even non-technical users to import data from Excel to SQL Server in a simple, secure and structured way.

  • How to Update an SQL Table from Excel

    Feb 5th, 2019

    If you want to easily let your non-technical users update and manage SQL Server data from Excel,click here to download the SQL Spreads Excel Add-In. 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 …

  • How to insert data from Excel to SQL Server

    May 4th, 2017

    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.

  • Use Excel to update data in SQL Server Views

    Nov 28th, 2016

    If you want to easily let your non-technical users update and manage SQL Server data from Excel, click here to download the SQL Spreads Excel Add-In. To enable users to work with data from several different tables when updating data in Excel to SQL Server, the latest release of SQL Spreads now supports working with …

  • How to use Excel to update SQL Server data

    Oct 17th, 2014

    If you want to easily let your non-technical users update and manage SQL Server data from Excel, click here to download the SQL Spreads Excel Add-In. 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 …