SQL Spreads release 5.1.07 - Excel to SQL Server

The Excel and SQL Server experts blog
SQL Spreads release 5.1.07
Johannes Åkesson - Jul 01, 2020
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 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 DateTimeOffset column.
- Added support for using key columns with a DateTime data type.
- Fixed issue when having Drop Down lists where leading zeros from the key/code value were dropped.
- Fixed issue when creating a table with the TableCreator and having special characters in the table name.
- Fixed issue with LastN- Designer column filters not returning all rows in the specified filter condition.
Download the latest version of SQL Spreads »

Comments are closed.

Use Excel to update your data in SQL Server?

Try the SQL Spreads data management solution to update and manage your SQL Server data from within Excel.