Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Building Pivot table from Access data
Hi,
I have a load of data in Access (too much tyo use Excel). I would like to use a pivot table but dont know how to link it to the Access data. Can someone please give me an idiot's guide? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Building Pivot table from Access data
When ypu start the Pivot Table Wizard in Excel, choose External Data Source.
You will need MS Query installed but should then be able to just follow the prompts. HTH - Sheila www.c-i-m-s.com MS Office training - London "Newbie" wrote: Hi, I have a load of data in Access (too much tyo use Excel). I would like to use a pivot table but dont know how to link it to the Access data. Can someone please give me an idiot's guide? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Pivot table formats text data with 2 decimals | Excel Discussion (Misc queries) | |||
Pivot Table Data Field Query | Excel Worksheet Functions | |||
pivot table | Excel Discussion (Misc queries) | |||
Pivot Tables, Help? | Excel Discussion (Misc queries) |