Data Import From Access

The UK's most regular instructor-led training courses.
Training information: excel+training · Advanced.excel · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

HANNES has attended:
Excel Advanced course

by - delegate HANNES [2 posts] (2008 May 6 Tue, 17:03) Reply

How do I imoort data from Acccess into a PivotTable in excel.

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course				List price £245
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 May 20 Tue	Bloomsbury	7	book now	£218	£240
2003/XP	2008 May 21 Wed	Southwark	5	book now	£219	£235
2003/XP	2008 May 21 Wed	Bayswater	6	book now	£195	£205
2003/XP	2008 May 23 Fri	Bloomsbury	6	book now	£214	£230
2003/XP	2008 May 30 Fri	Southwark	6	book now	£214	£230
2003/XP	2008 Jun 4 Wed	Bayswater	7	book now	£203	£230
Full Schedule: See all 153 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Data Import From Access

by - trainer Tracy platinum contributer [586 posts] (2008 May 6 Tue, 18:26) Reply

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

· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Microsoft Excel Training: Essential for Today's Employees
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· How to Create Better Excel Spreadsheets: Part Two
· Crazy Things People Have Done With Excel

Please browse our web site to find out more about
excel+training and other Microsoft training courses.