How to update data in SQL Server using Microsoft Excel and SQL Spreads (a commercial product).

In this video, I will show you how you can use SQL Spreads (a commercial data management solution) and its Excel Add-In to update and manage data in tables in SQL Server.

[RickArendt]

This is probably what I am looking for. Pity that functionality is not built into Excel but I would spend 10 times the cost of your product trying to replicate its functionality.

[rubenrosado]

Hi Johannes,

I have a product offered through a paid subscription on my website. The subscription allows users to download my excel sheet. The problem is that my spreadsheet is updated up to 30 times per day. The user currently needs to download it again and again to get the updated data.

Do you know how I can set up a system whereby my users can refresh the sheet from their own PC's, still honoring the subscription?

[krishan]

This is not a native feature in EXcel and cost over $400/-

[rafaelagrava]

hi i just want to ask what if i update in mysql database do you think it will update to in excel?

[faye]

Sadly, this is not part of MS Excel ... BUT IT SHOULD BE!!!

[Ing.RaulPadilla]

how to enable sql spreads tab in excel? I can not watch this thanks you!

[lmeza]

title should be:
"How to buy SQL Spreads to use Microsoft Excel to update data in SQL Server"

[NelsonFilipeCosta]

only works with mssql, if you use mariadb or mysql you are wasting your time