Merging parts of two spreadsheets

[ChrisB]

I have one main spreadsheet, with about 5 columns of information,
including PRODUCT_ID , PRODUCT_DESC , PRODUCT_PRICE , PRODUCT_NAME ,
PRODUCT_WEIGHT.

I have a secondary spreadsheet with 3 columns of information, including
PRODUCT_ID , PRODUCT_PRICE , PRODUCT_WEIGHT.

Is there a query or function I can use to Import PRODUCT_PRICE and
PRODUCT_WEIGHT from my secondary spreadsheet into my main spreadsheet
in the correct columns, but at the same time have the PRODUCT_PRICE and
PRODUCT_WEIGHT correspond with the correct PRODUCT_ID from my main
spreadsheet , because they are out of order.

any help is greatly appreciated...thnx in advance

 

[John Vinson]

I have one main spreadsheet, with about 5 columns of information,
including PRODUCT_ID , PRODUCT_DESC , PRODUCT_PRICE , PRODUCT_NAME ,
PRODUCT_WEIGHT.

I have a secondary spreadsheet with 3 columns of information, including
PRODUCT_ID , PRODUCT_PRICE , PRODUCT_WEIGHT.

Is there a query or function I can use to Import PRODUCT_PRICE and
PRODUCT_WEIGHT from my secondary spreadsheet into my main spreadsheet
in the correct columns, but at the same time have the PRODUCT_PRICE and
PRODUCT_WEIGHT correspond with the correct PRODUCT_ID from my main
spreadsheet , because they are out of order.

any help is greatly appreciated...thnx in advance

Are you talking about importing Spreadsheets into Microsoft Access
(the subject of this newsgroup), or are you working just in Excel? If
the latter I'd strongly suggest that you repost your question in an
Excel newsgroup.

FWIW this sounds like an application that is tailor-made for Access.

John W. Vinson[MVP]

 

[ChrisB]

I am importing my excel spreadsheets into access to hopefully be able
to run a query that would allow me to match product prices to their
corresponding product IDs in columns within access, then exporting back
to excel as a tab delimited.

 

[John Vinson]

I have one main spreadsheet, with about 5 columns of information,
including PRODUCT_ID , PRODUCT_DESC , PRODUCT_PRICE , PRODUCT_NAME ,
PRODUCT_WEIGHT.

I have a secondary spreadsheet with 3 columns of information, including
PRODUCT_ID , PRODUCT_PRICE , PRODUCT_WEIGHT.

Is there a query or function I can use to Import PRODUCT_PRICE and
PRODUCT_WEIGHT from my secondary spreadsheet into my main spreadsheet
in the correct columns, but at the same time have the PRODUCT_PRICE and
PRODUCT_WEIGHT correspond with the correct PRODUCT_ID from my main
spreadsheet , because they are out of order.

any help is greatly appreciated...thnx in advance

Thanks for the clarification (elsewhere in the thread). It was far
from obvious from this message that you were even USING Access.

This is perfectly straightforward. Create a new Query. Add both tables
(imported, or linked from Excel). Join the two tables by dragging
Product_ID from one table to Product_ID in the other. Add whatever
fields you want to see.

You can then export all the fields from the joined query back to Excel
if you wish.

You'll need to decide what to do if there are conflicting values for
Product_Price or Product_Weight between the two sheets - it's still
not clear to me which you mean.

If you want a single Access table with (say) the five fields in your
first table, updating the price and weight to the values from the
second table, change the joined query to an Update query; under
Table1.Product_Price put

[Table2].[Product_Price]

and similarly for Product_Weight.

and similarly for the product_weight. If Product_ID is a Primary Key
in Table1, this will let you update all the records in one swell foop.

John W. Vinson[MVP]