Data Import From Access

Resolved · Low Priority · Version 2003

Tue 6 May 2008, 17:01 Delegate 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:27 Trainer Tracy said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Use Paint Brush to Format More than one Cell

To copy a format to many cells or ranges

1. Select the cell with the format that you want to copy

2. Double-click on the paint brush

When you move to the cell where you want to paste the format you will notice that a paint brush follows the cursor.

Paste the format to all the cells or ranges you need to format.

When finished go back to the paint brush on the tool bar and single click on it to deactivate the function.

View all Excel hints and tips