Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel and MDB Datbase Files
Hi All,
I admit I am a complete novice on this aspect of using Excel. My requirement is as follows. I have an Access Database called nt1.mdb on drive D: in which there is one table (Table1) of data, indexed on column1 I wish to connect to this database and search the contents of Table1 for a value in column1 that has been entered into an Excel userform. The values of the other columns in Table1 should be returned if the value is found. How do I connect to the mdb, do the search and read the resulting values from the table? Any help gratefully received. Cheers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting a datbase | Excel Discussion (Misc queries) | |||
Criteria for datbase function in one row? | Excel Worksheet Functions | |||
What driver to use to filter a datbase (.txt) on Notepad? | Excel Discussion (Misc queries) | |||
Datbase check | Excel Worksheet Functions | |||
force upate to datbase using save as | Excel Programming |