Beyond Excel: VBA and Database Manipulation:

March, 2010

1

March 23, 2010  5:09 PM

Updating Databases from Excel – First Looks

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

Here is an example of an update spreadsheet.  We will use it in our tutorial. It updates the target stocking level ("Target Lvl") for Products in the Northwind database.  It could just as easily, with different configuration, update an...

March 17, 2010  8:19 PM

Updating Databases from Excel – The Basics

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

Last post I encouraged readers to approach updating databases with care and professionalism. Some may wonder why then, use Excel at all if updates require the level of care in traditional programming. The answer is that Excel is a standard means for exchanging data. As you know, the world is...


March 11, 2010  8:43 PM

Updating Databases from Excel

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

It seems almost every web portal that lists data includes an export to Excel, CSV, or XML, or combinations thereof.  What we are going to start exploring will enable you to capture that data, massage it, save it, and merge it with existing systems - using nothing more than Excel and...


March 4, 2010  6:32 PM

Drill Down – Part 2

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

Before we get to coding, let's look at the final product.  When we click our 'easy' button, our spreadsheet prompts us for dates, customers, and products.  If we just take the defaults, everything will be loaded from the NorthWinds database - like this: [caption id="attachment_544"...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: