Use ActiveX data object to select Access data in VBA

There are two way to get Access data(.wdb and so on), DAO and ADO.
DAO use the reference of MS DAO Object Lib, and ADO use the reference of ActiveX Data Object Lib.


Originally published at bustta.logdown.com. @ April 3, 2013

Kenneth Hung-Ju Tsai

Written by

Software Engineer

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade