Set a reference (Projects menu - references) to the Microsoft ActiveX Data Objects library (ADO).
You can easily check it...
dim aaa as ADO... now you should see ADODB in the list .. if not then you haven't set the reference...
(sorry, but the F1 key could have helped you out pretty well here...)