SQL Spreads 3.1.50 is now available for download. The new release includes better handling and display of the database schema and a fix for the issue with the license being lost when upgrading Excel to a new version. Improved display of schema in Wizard and database export. Improved detection of column names in Edit Export …
- Product
-
-
- KEY FEATURES
- Excel to SQL Server Write-backExcel users can swiftly update and write-back data to SQL Server.
- Filter huge data setsImport large-scale data sets into Excel, even from tables with millions of rows.
- Foreign Key LookupsKey value lookups enable easy and integrity-focused relational data management for users.
- Explore all features
-
-
- Resources
- Pricing
- Company
- Try for free
The Excel and SQL Server experts blog
-
SQL Spreads release 3.1.50
Johannes Åkesson - Feb 12, 2016 -
SQL Spreads release 3.1.4
Johannes Åkesson - Feb 04, 2016SQL Spreads 3.1.4 is now available for download. Minor updates. Fixed issue with pasting into a filtered range with hidden rows. Download the latest version of SQL Spreads »
-
SQL Spreads release 3.1.3
Johannes Åkesson - Nov 30, 2015SQL Spreads 3.1.3 is now available for download. Fixed issue with Num Lock beeing turned off. Download the latest version of SQL Spreads »
-
SQL Spreads release 3.1.2
Johannes Åkesson - Nov 24, 2015SQL Spreads 3.1.2 is now available for download. The new release includes an update that will auto-detect available SQL Server instances. When selecting columns, there is a new “Select All”/”Select None” feature for tables with large amount of columns. The column width of the data imported into Excel will now auto-adjust the column size to …
-
SQL Spreads exhibiting at PASS SQL Saturday
Johannes Åkesson - Sep 01, 2015I am excited to announce that SQL Spreads is sponsoring the PASS SQL Saturday event in Gothenburg at September 5th. PASS is the global community for sharing knowledge and insights in the data analytics and business intelligence technologies on the Microsoft platform. Read more about the event >>
-
SQL Spreads release 3.1.1
Johannes Åkesson - Aug 19, 2015SQL Spreads 3.1.1 is now available for download. The release includes a few minor updates. Added support for using columns with numbers-only names. Fixed issue with installing for 64-bit Office 365. Download the latest version of SQL Spreads »
-
SQL Spreads release 3.1.0
Johannes Åkesson - Aug 13, 2015SQL Spreads 3.1.0 is now available for download. The new release includes support to manage data in SQL Server tables that does not have any identity key. The major change in 3.1 is the ability to use a combination of key columns in a table. This removes the previous requirement for an Identity column in …
-
SQL Spreads release 3.0.6
Johannes Åkesson - Apr 07, 2015A new release of SQL Spreads is now available for download. The new release contains a number of updates and fixes: Improved support for Office 365. New improved layout of the import filter panel which now has buttons for Refresh and Save. New name on the “Database Submit” button: “Save to Database”. Fixed issue with …
-
SQL Spreads release 3.0.4
Johannes Åkesson - Feb 27, 2015With this new release, SQL Spreads is now an Excel only Add-In. The new Excel Add-In will connect directly from Excel to a SQL Server database. The SQL Spreads Excel Add-In makes it possible to manage data in SQL Server tables using Microsoft Excel. Download the latest version of SQL Spreads »
-
How to use Excel to update SQL Server data
Johannes - Oct 17, 2014End 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 …
Hi,
I am the founder of SQL Spreads, the lightweight data management
solution to update SQL Server data using Excel
In this blog we share the Excel and SQL Server knowledge that we have learnt during our work
with hundreds of customers worldwide.
Hope you find it useful!
Best regards,
Johannes Åkesson
Love Excel? Need to update SQL Server data?
Stena Center
412 92 Gothenburg
SWEDEN