| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you export a pivot table into Access? | Excel Discussion (Misc queries) | |||
| Export to Access from Excel | Excel Discussion (Misc queries) | |||
| Export from Access to Excel | Excel Programming | |||
| export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
| Export from Access to Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
