Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.querydao
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing data from a DataCom file into an Excel workbook | Excel Discussion (Misc queries) | |||
Importing data from an excel file to another with figures and lett | Excel Discussion (Misc queries) | |||
importing text file data into excel | Excel Discussion (Misc queries) | |||
Help with data importing from txt file to excel programmatically | Excel Programming | |||
Importing data from an Excel file on a web server using ADO/VBA | Excel Programming |