Embed OLE Excel Pivot Tables in Access Forms? Access v2003 and ff.

J

John

Hi,
With Access 2000 I had been able to create complex, multi-field,
"OLAP" queries and then convert them into Excel Pivot Tables via the
"old" Pivot Table Form Wizard.

That wizard built an embedded Excel OLE object into a form.
The users of this Access application know and love Excel pivots and
want this functionality (ie. Excel vs Access) continued.

Unfortunately, Access, from 2003 forward, seemed to want to create
their own version of a pivot table, via wizard. Not as good. Not as
rich. Not as appealing, especially with the Pivot capabilities of
Excel 07.

SO... I am assuming I can find some way in Access 03 / 07, sans
wizard, to continue to create such embedded OLE excel pivots? But I
can't find how. Tried to look behind both the wizard-ed form and the
embedded excel sheet for clues and find very little info.

Does someone know a way?
At present I keep an old copy of Access 2000 and go back and forth.
Kind of a hassle and someone must have come up with a better way.

Thanks in advance, John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top