View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy Patrick Molloy is offline
external usenet poster
 
Posts: 1,049
Default Can Excel directly access .mdb?

yes

menu: Data/Import External Data/New Database Query

select MS Access and follow the questions


"Brian" wrote in message
...
Howdy All,

I've been working on a project (with much help from Dave Peterson!)

I've imported some data from an Access Database.

Put I guess I should've asked this question first:

Can I set up a connection to the database and run macros and functions on
the data in Excel?

It seems to me if I can do that, I would save alot of time.

Thanks,
Brian