Database Connectivity with VBA
Nong Ye, Teresa Wu · 2014
ADO.NET includes many objects that can be used to work with data. The five core objects are Connection, Command, DataReader, Dataset, and DataAdapter. In VBA, the Connection, Command, and Recordset (instead of Dataset) objects are commonly used. We will briefly discuss the objects and illustrate their uses through some examples.