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

May 26, 2010 10:33 PM

Validating Data Entries

Posted by: Craig Hatmaker

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

Practically no one uses Excel to update databases directly. I think the reason is because we think of Excel as a tool that end users can do whatever they want to with and updating databases requires discipline. Just using Excel to shotgun records into a database can be...

0 Comments

RSS Feed

Email a friend

May 24, 2010 5:11 PM

Building a Library of Routines for Updating – #7

Posted by: Craig Hatmaker

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

[caption id="attachment_687" align="alignright" width="91" caption="You are here (Click to enlarge)"]

0 Comments

RSS Feed

Email a friend

May 18, 2010 4:11 PM

Building a Library of Routines for Updating – #6

Posted by: Craig Hatmaker

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

[caption id="attachment_673" align="alignright" width="91" caption="Your are here (Click to enlarge)"]

0 Comments

RSS Feed

Email a friend

May 12, 2010 7:47 PM

Building a Library of Routines for Updating – #5

Posted by: Craig Hatmaker

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

[caption id="attachment_666" align="alignright" width="91" caption="You are here (click to enlarge)"]

0 Comments

RSS Feed

Email a friend

May 6, 2010 8:34 PM

Building a Library of Routines for Updating – #4

Posted by: Craig Hatmaker

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

We are just about finished with adding support routines for updating, inserting, and deleting records in a database. As a reminder, these routines should never need modification. The first routine should go in modSQL. It is used to create a connection object that can be reused. This...

0 Comments

RSS Feed

Email a friend