| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup in Excel but pulling from Access
I dont even know where to start.
What I need to do is a lookup based on an Excel spreadsheet: show result in B2 based on Criteria in C2 but the lookup done from a Access Database Table based on Excel C2 = Field in Database. Any help would greatly be appreciated! -- ca1358 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Lookup in Excel but pulling from Access
Look at Mr. Erlandsen's site for information on use ADO.
http://www.erlandsendata.no/english/...php?t=envbadac -- Regards, Tom Ogilvy "ca1358" wrote in message ... I don't even know where to start. What I need to do is a lookup based on an Excel spreadsheet: show result in B2 based on Criteria in C2 but the lookup done from a Access Database Table based on Excel C2 = Field in Database. Any help would greatly be appreciated! -- ca1358 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pulling mulitple fields from a table through lookup | Excel Discussion (Misc queries) | |||
| Excel VBA pulling data from Access | Excel Programming | |||
| Pulling Access data into Excel | Excel Programming | |||
| Using InputBox to get desired date for a Query pulling data from Access into Excel | Excel Programming | |||
| Using InputBox to get desired date for a Query pulling data from Access into Excel | Excel Programming | |||
Hybrid Mode
