Posted by
Andy Brown on 06 February 2012 | no comments
Sometimes in Excel (for example) you'll need to retrieve data from a SQL
Server table, an Access query or even a table in Oracle, Ingres or the like.
This blog explains how to do this!
This topic is stuffed full of theory about things like cursors and
recordsets, but the strange thing is that the resulting code can be copied and
pasted whenever you need to use it, without always needing to understand exactly
what's going on behind the scenes!
The first thing you'll need to do to work with database records is to link to
the ActiveX Data Objects library (called ADO by its friends).