Category Archives for "Excel SQL Data"

0 Export Update SQL Server table data with Excel

This is a long video but I really wanted to try and make my steps and explanations as clear as possible to follow. I hope that you will this video informative and helpful in your endeavor to develop an Excel tool to export, insert and update SQL database data using Excel. Please leave comments below and let me know what you thought of the video and if you have any questions.

PART 1:

This will be the first part of my video training series where I will teach you how to Export and Update SQL Server table data using Excel in a step by step approach. In this first video I will show you how to add a button in Excel with VBA code behind the button that will export SQL data from an SQL table out of the AdventureWorks2014 sample SQL Server database.

0 Video: SQL Bulk Update Data with Excel

Excel is an excellent tool for bulk data updating and importing into SQL databases. It may sound unsophisticated, but Excel is a powerful yet simple solution for bulk data editing. No third-party programming is involved other than using SQL and Visual Basic for Applications (VBA) – which are already part of Excel. Sometimes the simplest solution is the most effective.

You can see a demonstration of how this works here: