• SQL Spreads Blog

  • How to Export Data from SQL Server to Excel

    Andy McDonald - Aug 26, 2021

    In a previous article, SQL and Excel: Why you need both, we showed that for many businesses the use of both SQL Server and Excel is an optimum approach to data management.  For organizations that use SQL Server and Excel extensively, there is often a need to export data from SQL Server to Excel.  The …

  • SQL Server Import and Export Wizard Guide

    Andy McDonald - Jul 20, 2021

    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 get data into or out of a SQL Server database, but it caters to several scenarios. Although like most Microsoft wizards …

  • Connect Excel to SQL Server: 3 Easy Steps

    Andy McDonald - Jun 29, 2021

    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 …

  • SQL Spreads release 6.0.30

    Johannes Åkesson - Jun 17, 2021

    SQL Spreads 6.0.30 is now available for download. This new release introduce a new feature to use the Tree filter selection as the key column when inserting new rows into a table. Added a new Parameter selection dialog to easily insert Tree Filter and Cell parameters. Added the possibility to remove key columns that are …

  • SQL and Excel: Why you need both

    Andy McDonald -

    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 …

  • How to use XLOOKUP: Guide and Examples

    Andy McDonald - May 27, 2021

    Introduction 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 last year.  It overcomes some …

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

    Andy McDonald - May 12, 2021

    Introduction Comma Separated Values (CSV) files are commonly used to exchange data from one system or application to another.  The simple format of the csv file makes them ideal for exporting data from one place and importing it to another.  A common use case, for example, is to export the data from an accounting or …

  • SQL Spreads release 6.0.17

    Johannes Åkesson - Mar 30, 2021

    SQL Spreads 6.0.17 is now available for download. SQL Spreads 6.0 introduces the new Lookup feature to easily lookup key values from a related table or a list of fixed key-text pairs. A drop-down list in Excel allows the user to select a text item, while the corresponding key will be written to the database. …

  • SQL Spreads release 5.1.12

    Johannes Åkesson - Sep 30, 2020

    SQL Spreads 5.1.12 is now available for download. Added support for using key columns with the UNIQUE IDENTIFIER data type while also generating new IDs as a default value in SQL Server. Fixed issue with Designer being locked for new worksheets in certain cases. Minor bug fixes Download the latest version of SQL Spreads »

  • SQL Spreads release 5.1.07

    Johannes Åkesson - Jul 01, 2020

    SQL Spreads 5.1.07 is now available for download. The Excel table is now always resized to the number rows that are imported from the database. Added support for using SQL Server columns with the data type DateTimeOffset. Conflict detection will now work over different time zones when setting the ModifiedOn Change Tracking column to a …

  • Page 2 of 6«12345»...Last »
Envelope Iconsmall picture of an envelope signifying email Need help?