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

In the database, make a left join query that ties both tables together.

Pull this entire query into the spreadsheet.

*** IMPORTANT ***
do NOT manipulate the data on that sheet. It will be the raw data page and
you can use it to validate anything.

On another worksheet, make a pivot table based on the raw data sheet.
You'll be able to make the seperations you want..

"Stefan" wrote:

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

That works like a champ! Thanks a million!
--
Stefan Dimmick


"TomHinkle" wrote:

In the database, make a left join query that ties both tables together.

Pull this entire query into the spreadsheet.

*** IMPORTANT ***
do NOT manipulate the data on that sheet. It will be the raw data page and
you can use it to validate anything.

On another worksheet, make a pivot table based on the raw data sheet.
You'll be able to make the seperations you want..

"Stefan" wrote:

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