Open excel pivot source data in Access?

7

770.wookie

I have an Excel (2003) pivot table based on an Access table. Is there a way
to open the source data in Access?
 
N

Nick Hodge

To me this doesn't make sense. You P/T is based on data in Access and you
want to open it in Access. Is it not already there? If you are looking to
mirror the pivot table in Access then look for a crosstab query or produce a
report

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
web: www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html
 
Top