Hallo everybody!
I have a problem with exporting an excel pivot table to access. I can't
convert it into a table directly in excel, cause the initial data range
contains a lot more rows than excel worksheet. I don't have a direct access
to the pivot source. I tried to save the pivot as ODC via
{activesheet.pivottables(1).pivotcache.saveasodc(" odcfilename")} command - it
returned a run-time error. I just don't know what to do...
Could anybody help me, please?
Thanks!