View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.querydao
jimmy shaker. jimmy shaker. is offline
external usenet poster
 
Posts: 2
Default Importing/querying data from .mdb file into Excel



Hello everyone, here's my situation...

I have a Microsoft Access database file that contains information on
computer systems, such as their computer names, their IP addresses,
CPU model, POC name, etc.

What I want to do with an Excel file is that when I type the computer
name in a cell, Excel will then query the .mdb file and automatically
fill in other cells with the POC name, IP address, and CPU model of
that particular computer system that is contained in the .mdb file.

Question #1
Is this possible?

Question #2a
If it is possible, what would be the best means of doing this??

Question #2b
If it's not possible, what would be an alternative to doing what I
need it to do (querying the .mdb for information based on a computer
name)?

Thanks in advance for any help you can provide.

-js.