Microsoft Excel has no export capabilities.

We can use three techniques to add this feature:

  • VBA applications.
  • Visual Studio Tools for Office solutions.
  • Third party Excel Add-Ins.

The articles in this section describe all three techniques and contain a working code for a quick start.

Take a look at the last article.

For example, SaveToDB Add-In allows editing SQL Server table data using Excel without any coding.

With a little server-side coding, you can use stored procedures as Excel event handlers and update database data on the Cell Change event.