Video: SQL Bulk Update Data with Excel - KuduTek.com

Video: SQL Bulk Update Data with Excel

Follow Jon Muller at Kudutek.com for Excel SQL and Data Tips and Tricks

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:

Introduction to the KuduTek Excel Equipment Maintenance Utility

In this demonstration I show you how the popular KuduTek Excel Equipment Maintenance Utility works. This utility was specifically designed to access and edit SQL Server data which is used by e-automate, an ERP product from ECI Solutions and it is primarily used by office equipment dealers. However similar solutions can be developed for other databases in addition to Microsoft SQL Server. As a matter of fact, most mainstream databases like Oracle, MySQL, DB2, PostgreSQL, etc. can be worked with in a similar way.


Help Me Spread the Word!

About the Author

Jon is a recognized change agent with a passion for process optimization through data intelligence and has designed many solutions that have played an integral part in efficiency, productivity, revenue generation and cost savings for his clients.

Leave a Reply 0 comments

Leave a Reply:







>