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.

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.