Open a DB connection in VBA

  • Thread starter Thread starter Dkso
  • Start date Start date
D

Dkso

Can anyone tell me where I get some info / examples of connecting to a DB via MS Excel VBA programming.
I have done a bit of VBA before but have never tried connecting to an external DB. I would like some examples please. Personal or web sites gratefully accepted.

Thanks in advance.

Dean
 
http://www.erlandsendata.no/english/vba/adodao/index.php

If you type "ado dao excel access" into google you will find many more...

--
Michael Hopwood


Can anyone tell me where I get some info / examples of connecting to a DB
via MS Excel VBA programming.
I have done a bit of VBA before but have never tried connecting to an
external DB. I would like some examples please. Personal or web sites
gratefully accepted.

Thanks in advance.

Dean
 
Back
Top