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

  • Thread starter Thread starter PQGUY
  • Start date Start date
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...
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can you use ADO from Excel to run an Append Query in Access 2
to DAO, or not to DAO 2
Essbase Add-in VBA programming question 1
DAO library 1
How to install DAO? 3
Add Microsoft ActiveX Data Objects 2.8 Library in code 10
DAO - Accessing open Excel file issue 1
DAO IS DED 16

Back
Top