D
Daddyslipdisk
I have a file that a client gave me that has all of her store information in
it. It's a file that was given to her from the product distributor. It has
multiple tables and they are related to each other in some form or fashion.
One table has product pricing, one has special pricing for members, one has
shipping info, one has the image names for products, one has product
categories, etc. I tried to set up relationships between them and query it
into one big table to use in Excel, but one of two things happen. Either the
products are missing fields or the table only has 30 or so rows (although the
file has about 8000 products in it).
So here's my question. Obviously this file has pre-set relationships
created for it. Somehow there's supposed to be a query done that will pull
all of the information from each and every table and create one big file with
all of the fields pulled in from the various tables and input into one big
csv or tab delimited file that can be exported into Excel. But I can't
figure out how to do that for the life of me, but I know it's an easy thing
to do if you actually know what you're doing. I wouldn't even have a
problem exporting each table one by one and then combining them, but each
table outputs a different row count. For instance, the category table only
outputs 20 rows. But the product table is supposed to access that category
file and based on the ID, input the correct category name on each product
line. And so I have this Access file with a bunch of tables that have the
info sorted out like that and no idea how to generate the one import file
that successfully pulls the correct info from the other tables.
So in short, how do I export information from the multiple tables in Access
into one big file that contains all of the fields from all of the tables into
Excel? And in language for an Access newbie.
it. It's a file that was given to her from the product distributor. It has
multiple tables and they are related to each other in some form or fashion.
One table has product pricing, one has special pricing for members, one has
shipping info, one has the image names for products, one has product
categories, etc. I tried to set up relationships between them and query it
into one big table to use in Excel, but one of two things happen. Either the
products are missing fields or the table only has 30 or so rows (although the
file has about 8000 products in it).
So here's my question. Obviously this file has pre-set relationships
created for it. Somehow there's supposed to be a query done that will pull
all of the information from each and every table and create one big file with
all of the fields pulled in from the various tables and input into one big
csv or tab delimited file that can be exported into Excel. But I can't
figure out how to do that for the life of me, but I know it's an easy thing
to do if you actually know what you're doing. I wouldn't even have a
problem exporting each table one by one and then combining them, but each
table outputs a different row count. For instance, the category table only
outputs 20 rows. But the product table is supposed to access that category
file and based on the ID, input the correct category name on each product
line. And so I have this Access file with a bunch of tables that have the
info sorted out like that and no idea how to generate the one import file
that successfully pulls the correct info from the other tables.
So in short, how do I export information from the multiple tables in Access
into one big file that contains all of the fields from all of the tables into
Excel? And in language for an Access newbie.