| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.links
|
|||
|
|||
vlookup from Access db
Many sheets with many lookups to many tables in a database suggests to
me that the design of your application may not be ideal for Excel, and I would hesitate to promote the recordset idea in this case. Try the QueryTable approach and see how you get on with it. Have you considered doing it all in Access? Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using VLOOKUP when referencing data from Access | Excel Worksheet Functions | |||
| VLOOKUP with restricted access rights | Excel Worksheet Functions | |||
| VLOOKUP from Access Tables | Excel Discussion (Misc queries) | |||
| VLOOKUP from Access Tables | Excel Worksheet Functions | |||
| vlookup and microsoft access | Excel Worksheet Functions | |||
Threaded Mode
