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.