Importing data from Access and creating statistics and a pie chart

[Guest]

I have an Access database field that contains the name of a part, which is
one of 93 parts. I want to be able to import this data to Excel so that I
can statistically show the numbers of each type of part sold within a
specific time frame. For instance, we sold 25 widgets last quarter which is a
15% increase over the previous quarter. The imported data would be broken
down by part name, and then converted to a pie chart. I think I know how to
limit the time frame in Access, but am lost when it comes to importing the
data and generating the statistics in Excel and creating the pie chart. Any
help would be appreciated. I will also post this in the Access Discussion
groups

 

[Del Cotter]

I have an Access database field that contains the name of a part, which is
one of 93 parts. I want to be able to import this data to Excel so that I
can statistically show the numbers of each type of part sold within a
specific time frame.

What I always do is Select All, Cut, and then Paste into Excel. But this
isn't really a charting question, it's just that your eventual aim is to
make a chart. Perhaps one of the other Excel newsgroups can help you?