Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

data import from access

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data Import From Access

Data Import From Access

ResolvedVersion 2003

HANNES has attended:
Excel Advanced course

Data Import From Access

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

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

Excel tip:

Number format shortcut

Ctrl+Shift+! applies the Number format, with two decimal places

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.