Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data Import From Access
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Data Import From Access
Resolved · Low Priority · Version 2003
Reply Tue 6 May 2008, 17:01Delegate HANNES said...
HANNES has attended:
Excel Advanced course
Data Import From Access
How do I imoort data from Acccess into a PivotTable in excel.
For upcoming training course dates see: Pricing & availability
RE: Data Import From Access
Hi Hannes,
I think this is the same question!! But here is the answer again!!
My suggestion would be to import the data from access first. (Data>Get External Data> locate file) then turn the data once imported into a Pivot Table. (Data> Pivot table)
If you are unfamiliar with how to create a Pivot table let me know but I would do it in two stages.
kind regards and I hope you enjoyed the training
Tracy
|