Best way to do this is via the VB wrapper from Olaf Schmidt,
vbRichClient5.
Can download he
http://www.vbrichclient.com/#/en/About/

Perhaps not the "Best way" in this case! I have Olaf's package but
never used it for accessing data with VBA since it requires shipping a
dependancy. (This may also require registering if not using Olaf's
method of running DLLs reg-free in VBA projects!<g) This is not a bad
thing if a VBA project consists of more than 1 file anyway, but most
are a single workbook (which may or may not be shared over a network)!

Otherwise, the MS ActiveX Data Objects libs install with Windows and so
already exist on host machines. Also, there's loads of code samples
available using both the JET or ACE providers to work with databases
from/in Excel. JET works with both early/late versions of MSO, ACE only
works with v12 and later.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion