Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limit using pivot table with Access database?
We are using a pivot table to query data held in an access database. As the
year progresses we reach nearly a million records which it seems that the Excel pivot table can not handle. Is this a limitation of Excel or our PC's? I know we can be more specific to reduce the amount of data during the MS Query stage, but sometimes this is very inconvenient. We remove a years data in January, but of course the problem get worse as we go through the year. Any suggestions so we can keep all the data we want in our database and query it as well? -- Learning slowly but surely!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limit using pivot table with Access database?
You are not limited by your pc but rather by the amount of memory XL can
access. That depends on your version of XL. If you want more info on that check out http://www.decisionmodels.com/memlimits.htm But in short you need to figure a way to limit the number of rows either by doing some pre-aggregation (group records together) on the access side or by purging data. -- HTH... Jim Thomlinson "peb" wrote: We are using a pivot table to query data held in an access database. As the year progresses we reach nearly a million records which it seems that the Excel pivot table can not handle. Is this a limitation of Excel or our PC's? I know we can be more specific to reduce the amount of data during the MS Query stage, but sometimes this is very inconvenient. We remove a years data in January, but of course the problem get worse as we go through the year. Any suggestions so we can keep all the data we want in our database and query it as well? -- Learning slowly but surely!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Pivot Table connected to an Access Database Data Source | Excel Discussion (Misc queries) | |||
Creating pivot table from Access database | Excel Discussion (Misc queries) | |||
Create Pivot from access database by VBA | Excel Discussion (Misc queries) | |||
vlookup and Access Database Table | Excel Discussion (Misc queries) | |||
Pivot Table against an Access Database | Excel Discussion (Misc queries) |