Writing from Excel to Access DB

[Bob Kaku]

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?

 

[merjet]

Use the menu Tools | References to check
Microsoft DAO x.x Object Library.

HTH,
Merjet