Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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...
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 257
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Excel 2003 clark Excel Worksheet Functions 2 May 31st 08 01:37 AM
Microsoft Excel 2003 rspikes New Users to Excel 1 April 8th 08 12:16 AM
Help on Microsoft Excel 2003 Gontiz Excel Discussion (Misc queries) 1 January 18th 06 03:01 PM
Microsoft Excel 2003 tp Excel Worksheet Functions 3 December 8th 05 06:48 PM
Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet Graham Jones Excel Discussion (Misc queries) 1 May 13th 05 12:58 AM


All times are GMT +1. The time now is 03:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"