Data Import From Access

The UK's most regular instructor-led training courses.
Training information: excel training · Microsoft excel training · Microsoft Excel Training UK
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:01) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course				List price £225
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 May 19 Mon	Bloomsbury	0	FULL
2003/XP	2008 May 20 Tue	Tooting	0	FULL
2003/XP	2008 May 20 Tue	Bayswater	1	book now	£195	£205
2003/XP	2008 May 22 Thu	Bloomsbury	7	book now	£188	£215
2003/XP	2008 May 29 Thu	Southwark	4	book now	£207	£215
2003/XP	2008 Jun 3 Tue	Bayswater	5	book now	£198	£215
Full Schedule: See all 169 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Data Import From Access

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

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