| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data too large for Excel, need to query Access data for results
I've got a large database within Excel, and will soon exceed 70,000
rows. Excel's limit, as we know is 65,536 Its used to support VLOOKUP and IF functions, and return prices and purchasing data for items on another worksheet, which usually contain 1000 items or less. Short of paring down my database, it there a way to keep the data in MS Access, and query the lookup answers from within Excel, and have Excel just display the correct prices and other data pertinant to that line? Sue |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why are access query results different in Excel | Excel Discussion (Misc queries) | |||
| Excel Data Query from Access | Excel Discussion (Misc queries) | |||
| Access query results to Excel | Excel Discussion (Misc queries) | |||
| Getting Access Query Data to Excel | Excel Programming | |||
| Copy the results of an Access query into an Excel spreadsheet | Excel Programming | |||
![Susan[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
