Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
I'm new to programming Excel but have been at it for a couple years now with Access. Can a macro be written to search an access table using data from an excel list as criteria? If so can the fields returned in the query (i.e. select * from table1 where column1 = an excel list value) be assigned to individual cells in the worksheet? Just wondering if its possible. Thanks for any insight. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy Records from Access Database table(more than 5 lakh records in this table) to Excel Sheet | Excel Programming | |||
Importing data from Access to Excel, but I need to vary the table from Access | Excel Programming | |||
How do i build a search table in excel | Excel Worksheet Functions | |||
Excel function to search and access database problem | Excel Programming | |||
Linking a table in Access to a table in Excel using MS Query | Excel Programming |