April 20, 2010 1:16 PM
Posted by: Craig Hatmaker
database,
development,
excel,
Microsoft Excel,
ms query,
odbc,
sql,
tutorial,
vba[caption id="attachment_685" align="alignright" width="91" caption="You are here (Click to enlarge)"]![]()
April 15, 2010 8:10 AM
Posted by: Craig Hatmaker
database,
development,
excel,
Microsoft Excel,
ms query,
odbc,
sql,
tutorial,
vba[caption id="attachment_682" align="alignright" width="91" caption="You are here (Click to enlarge)"]![]()
April 5, 2010 11:24 AM
Posted by: Craig Hatmaker
database,
development,
excel,
Microsoft Excel,
ms query,
odbc,
sql,
tutorial,
vba As promised in the last post, here are descriptions of each column in the fields table.
[caption id="attachment_583" align="alignnone" width="587" caption="Fields Table (click to enlarge)"]
March 23, 2010 5:09 PM
Posted by: Craig Hatmaker
database,
development,
excel,
Microsoft Excel,
ms query,
odbc,
sql,
tutorial,
vbaHere 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
Posted by: Craig Hatmaker
database,
development,
excel,
Microsoft Excel,
ms query,
odbc,
sql,
tutorial,
vbaLast 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
Posted by: Craig Hatmaker
database,
development,
excel,
Microsoft Excel,
ms query,
odbc,
sql,
tutorial,
vbaIt 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
Posted by: Craig Hatmaker
database,
development,
excel,
Microsoft Excel,
ms query,
odbc,
sql,
tutorial,
vbaBefore 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"...
February 24, 2010 6:40 PM
Posted by: Craig Hatmaker
database,
development,
excel,
Microsoft Excel,
ms query,
odbc,
sql,
tutorial,
vbaLast post I showed how we can present summarized data when what our users want is supported by detail that would fill up tens of thousands of rows. When we summarized the data, in a sense, we duplicated the functionality of a simple "pivot table."
Pivot Tables have one feature we didn't...
