How do I add Microsoft DAO to the referenced lib in Excel 2003

P

PQGUY

We are trying to read data from an Acess dBase from Excel useing VBA.

We have code examples , but keep finding that we need (or think we need) to
add a Microsoft lib DAO or ADO...

Looking for help...
 
B

Bob Bridges

I've read Access from Excel, but never so far in VBA, so I'm
not sure what problem you're encountering. But for this to
work you do have to own a copy of Access; otherwise the
Access objects that you'd need to use won't be in your
registry.

At least, that's what I think. I recently went through this
trying to get Excel to read Project for a friend of mine; I had
to intsall a free trial version of Project to be able to write the
code. Is Access installed on that PC?
 
Top