I want to be able read rows from a spreadsheet and insert into a MS Access
database. I'm having a problem in just declaring object variables as
follows:

Dim db As DAO.Database
Dim rs As DAO.Recordset

I get a compile error on both of these declaration statements. The error
message is "User-defined type not defined". Do I have pre-define the
"Database" and "Recordset" data types?

--
Bob Kaku
Email:
http://www.majesty.org