Beyond Excel: VBA and Database Manipulation:

excel


September 17, 2009  6:44 AM

Data Sources



Posted by: Craig Hatmaker
development, excel, Microsoft Excel, ms query, odbc, sql, vba

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



Posted by: Craig Hatmaker
database, development, excel, Microsoft Excel, ms query, odbc, sql, vba

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



Posted by: Craig Hatmaker
database, development, excel, Microsoft Excel, ms query, odbc, sql, vba

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


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: