excel pivot export to access
 

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!

excel pivot export to access
 

andriil;6228572 Wrote:
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!

Dear Andrill,

It looks like your post was a while ago. If anyone's still listening,
I've had this exact problem and can't find a solution anywhere online.
Any ideas (please...anybody)?

Benjamin


--
iambenjamin234