Yes, you need to use ADO. If I were you, I'd create the connection and command object. Something like this:

Dim cnn As ADODB.Connection

...