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

 

Training courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

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.08 secs.