Hello!
I want to use Excel document connect Access database via ADO Connection.
I claim the following sentence in my program:
Dim conn As ADODB.Connection

It prompt the following error message while I compile my program:
User's type undefine

I lookup Excel's help for ADO Connection. It just pivottable connect Access
database via ADO Connection has been told. This help is no use for me.
Please tell how to use ADO Connection in Excel VBA. Thanks!