Blog - Page 2 of 2 - KuduTek.com

7 reasons why Excel is great for database data bulk editing

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

Excel spreadsheets facilitate the overall bigger picture of the data on hand, all in one familiar sheet, and gives the user “data situational awareness”. Therefore it is easier for the user to make data cleaning and standardizing easier because the user can consider all the data in the same context.

It enables the data project owner to share spreadsheets with other individuals, in different departments, to review and edit the data in familiar Excel within their specific area of focus and data knowledge, without having to be logged into a specific software program.

Enables separation of data cleanup work from specific software program user login sessions.

The Excel approach eliminates multiple GUI steps to view, edit or add data.

Excel makes it easier to do data batch validation before actually posting data back, or inserting new data into database.

The use of copies of an Excel file for before and after serves as a simple archiving and backup solution of original data and data revisions. It adds a lot of flexibility.

Makes it easy to copy data from source to destination databases.

Flexibility and versatility of Excel functions for ad hoc data sort, filter, find and replace, cut or copy and paste, Excel data validation features, the sky is the limit!

Upcoming Excel Data Masterclass Videos

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

Hi, my name is Jon Muller, founder of the company KuduTek.

About 2 years ago I posted my first video on my youtube channel with the long title: Bulk Update Data with Excel | Excel SQL Database Update and Insert Utility.

I created that video because I wanted to promote the concept of using Excel as a viable and practical solution to edit and insert data in a SQL database in bulk. I also wanted to use that opportunity to promote my company KuduTek and my excel consulting service, and showcased the concept through demonstrating a specific example of how I developed the so-called “e-automate Equipment Maintenance Utility”.

Continue reading

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:

Continue reading
>