564 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Linking to ADO databases with VBA
Part one of a five-part series of blogs
Learn how to write VBA macros to add, edit and delete data in Access, SQL Server and other databases, using something called ADO.
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!
This tutorial shows how to connect to databases using VBA (we also offer classroom VBA courses). It covers:
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).
|Parts of this blog|
25 Aytoun Street