| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
read Access table from VBA
I have an Access database c:\test\val.mdb
In this database I have a table "values". Values has the fields "label1" and "date1". date1 is unique. Now from Excel VBA I want to read label1 from this table with date1 as key. Can someone tell me how this is done? Please be specific (an example would be best) - also indicate which references I need to include in VBA to use Access functionality Ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Connection of Excel 07 pivot table to Access Query makes DB read o | Excel Discussion (Misc queries) | |||
| How do I access the read-only box on my disc? | Excel Discussion (Misc queries) | |||
| Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
| Cannot access read-only documents. | Excel Discussion (Misc queries) | |||
| Sumproduct in Excel Spreadsheet to read Access db table | Excel Worksheet Functions | |||
![Ron[_13_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
