Beyond Excel: VBA and Database Manipulation:

September, 2009

1

September 24, 2009  4:18 PM

Automating Queries

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

We’ve been looking at using MS Query from XL to get at data stored on mainframes, servers, or you PC.  Hopefully you have experimented with MS Query.  MS Query represents what I refer to as a “manual method” because it involves no coding.  So let’s look at how we can...

September 22, 2009  9:06 AM

Creating a Query

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

So far we’ve discussed MS Query and its uses.  Today we’re going to see just how easy it is to use in 9 simple steps. Step 1 – Find Data You probably have a copy of a sample MS Access database called "Northwind" on your PC.  We will use it for this exercise.  The most...


September 18, 2009  3:53 PM

MS Query – Example Use

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

So far I’ve talked about how to use MS Query.  It’s easy.  It’s useful.  It’s free.  It’s included with every version of XL.  It works with just about any database provided you have the (usually free) ODBC driver.  Though we won’t be using MS Query in any of the spreadsheets we...


September 17, 2009  6:44 AM

Data Sources

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

In my last post, I shared how you can explore just about any database using MS Query, a useful, friendly, and free tool included with every version of XL.  To use it with your database, you must point it to the appropriate data source. 


September 10, 2009  7:28 AM

Manually Linking to Data – MS Query

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

Before tackling automated methods for incorporating data into XL, we should look at a surprisingly useful and free component included with every version of XL, MS Query.  MS Query provides a graphical interface into databases.  You can use it to explore database tables, examine columns and...


September 10, 2009  6:59 AM

Forward

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker
excel

Everyone knows Microsoft Excel is a powerful database manipulation engine, but data lives in databases and only a few Excel experts know how to exploit this natural synergy. If you are one of tens of thousands of business developers asked each day to:

  • Produce reports from systems...


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: