Excel and ADO 1

[comconrk]

I would like to use ADO in Excel, but when I try to use

Dim conn as ADODB.Connection

I get a compile error. I have added several references to my VBA macro, but I must not have found the correct one.

Which reference(s) should I be adding?

Thanks!

 

[PHV]

Microsoft ActiveX Data Object 2.# Library

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886