I am trying to pull data from Access into Excel. I have successfully done
so... well, to a point.

Here is my situation:

I have a database containing several tables. I only want to pull from two of
these tables. One contains inventory data and the other contains descriptions
of the data I want to pull. For instance, in the inventory table I have a
shirt. The shirt comes in several sizes, however the sizes are contained in a
seperate table containing the descriptions and how many of each for the
description. The two tables are tied together by unique ID's.

What I would like to do in Excel is first pull in the department. Under each
department I would then like to display each item code from the inventory
table. Under the item code I would then like to display each description for
that particular item and then list the number of items per description (or
number of items on hand for the item matching that description).

Again, while I am able to pull data into the spreadsheet, I cannot seem to
manipulate it into breaking the items down further, into their perspective
descriptors.

Any help would be appreciated.

Thanks in advance.
--
Stefan Dimmick