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

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...

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

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?

--- "PQGUY" wrote:
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.