How to use the SQL Spreads Excel Add In to update the data in a SQL Server table

Описание

In this video I will show you how you can use the SQL Spreads Excel Add-In to update data in a table in SQL Server.

I will walk through how to:
- Load the SQL Server table into Excel
- Select the columns to show to the user
- Select Read-Only columns
- Update the header names
- Filter and sort the data loaded from SQL Server

Lastly I will save some of the changes in the data in Excel to SQL Server, and also talk about sharing the Excel document with your end users.

You can download the SQL Spreads Excel Add-in from
https://sqlspreads.com