98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data Import From Access
Data Import From Access
Resolved · Low Priority · Version 2003
Tue 6 May 2008, 17:03Delegate HANNES said...
HANNES has attended:
Excel Advanced course
Data Import From Access
How do I imoort data from Acccess into a PivotTable in excel.
Tue 6 May 2008, 18:26Trainer Tracy said...
RE: Data Import From Access
Hi Hannes,
Thanks for the question. 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
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. |
Excel tip:Closing Multiple Open Worksheets At OnceWhen multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option. |
