Beyond Excel: VBA and Database Manipulation: March, 2010 archives

Updating Databases from Excel – First Looks

Posted by:

Craig Hatmaker

database

development

excel

Microsoft Excel

ms query

odbc

sql

tutorial

vba

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

Posted by: Craig Hatmaker

database, development, excel, Microsoft Excel, ms query, odbc, sql, tutorial, vba

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...

0 Comments

RSS Feed

Email a friend

March 11, 2010 8:43 PM

Updating Databases from Excel

Posted by: Craig Hatmaker

database, development, excel, Microsoft Excel, ms query, odbc, sql, tutorial, vba

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...

0 Comments

RSS Feed

Email a friend

March 4, 2010 6:32 PM

Drill Down – Part 2

Posted by: Craig Hatmaker

database, development, excel, Microsoft Excel, ms query, odbc, sql, tutorial, vba

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"...

0 Comments

RSS Feed

Email a friend