Access pivot table in Access

L

liligupta

Joined
Mar 29, 2010
Messages
1
Reaction score
0
I saw there is pivot table function (or something similar) in Access. I have over a million lines of data which I imported from Excel into access in a poor attempt to analyse it with Pivot function like I do in Excel. But I am too dumb to know to how to do it in Access. Can anyone give me some tip on this please? Or maybe I can still analyze the data in Excel with Pivot function, but how, with a million lines of data?
Thank you!
lili G.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access #Error & Excel Pivot 0
Pivot using 250,000 rows of data in Excel? 1
Multiple measures in MS Access pivot table-Sigma Value in Row not Column 0
Excel How do I create a pivot table in excel 2003? 3
Excel Error while updating an external data source into a pivot table! 0
Excel Excel Pivot Chart/Pivot Table query 0
Access Access 2007 DB reaching 2GB limit and Transform query 0
Export Pivot table 1

Top