Search results

Not seamless enough In MS Access VB I can access the workbook and using the pivotcache object I can report the record count using the record count property, so I know I'm connected to the underylying data. What I'd like to do is build a form around attaching the workbook and then just link to...

Anyone know how to do this? I know that a pivot table cache exists in the source excel workbook. I cannot query the original ODBC source of the cache, but I'd like to pull the data in the cache into access either by link or import in order to use queries.