Update query to not include skus NOT in target

[OldenMcdonald]

I have office 2010
Originally I attempted to do this with excel, but the formula used made cpu hit 100%

I have uploaded a sample file excel file.
I can if needed upload 4 separate delimited text files.

Goal
Update data from Tab 2 using tab 1 as source, NOT including data unique to Tab 1 first field then output data to tab3 or to new data file.

then

for tab 4
I need to know what skus from Tab 2 is NOT in tab 1



Turns out some active skus are being ghosted that is why I need tab 4
the attached file has a password of
test

sample_sheetB.zip.

[June7]

You have this data in Access database? Why not provide the Access file?

[OldenMcdonald]

Goal
Update data from [Table_B_list_of_active_skus] using [Table_A_inactive_plus_active] as source, NOT including data unique to [Table_B_list_of_active_skus] first field then output data to [Skus_in_Table_B_Updated_fromA_Data]

then

for [skus_inTable_B_not_in_TableA]
I need to know what skus from [Table_B_list_of_active_skus] is NOT in [Table_A_inactive_plus_active]


the zip file contains access database with 4 tables

file pass wor d is 1234

sample_sheetB.zip

[June7]

Have you tried the Find Unmatched query wizard? It generates this SQL:

SELECT Table_B_list_of_active_skus.SKU
FROM Table_B_list_of_active_skus LEFT JOIN Table_A_inactive_plus_active ON Table_B_list_of_active_skus.[SKU] = Table_A_inactive_plus_active.[sku]
WHERE (((Table_A_inactive_plus_active.sku) Is Null));

[OldenMcdonald]

Have you tried the Find Unmatched query wizard? It generates this SQL:

SELECT Table_B_list_of_active_skus.SKU
FROM Table_B_list_of_active_skus LEFT JOIN Table_A_inactive_plus_active ON Table_B_list_of_active_skus.[SKU] = Table_A_inactive_plus_active.[sku]
WHERE (((Table_A_inactive_plus_active.sku) Is Null));

That works great for then 2nd goal,{ Thanks}
but what about the 1st goal of creating a update table based upon the existing skus in table B using data A without including skus unique to table A ?

I have done a make table Query to take data from A and B to create Skus_in_Table_B_Updated_fromA_Data . It created the table BUT also updated the shipping amounts in table B. I do not want to modify the contents of table A or B
new access file attached pa s s word is 1234
sample_sheetC.zip

[June7]

You want to create a table that has Table_B SKUS and Table_A ShippingAmt1?

If you want all 3349 Table_B records:

SELECT Table_B_list_of_active_skus.SKU, Table_A_inactive_plus_active.ShippingAmt1 INTO TEST
FROM Table_B_list_of_active_skus LEFT JOIN Table_A_inactive_plus_active ON Table_B_list_of_active_skus.[SKU] = Table_A_inactive_plus_active.[sku];

If you want only the 3232 records with SKU in both tables:

SELECT Table_B_list_of_active_skus.SKU, Table_A_inactive_plus_active.ShippingAmt1 INTO TEST
FROM Table_B_list_of_active_skus INNER JOIN Table_A_inactive_plus_active ON Table_B_list_of_active_skus.[SKU] = Table_A_inactive_plus_active.[sku];

[OldenMcdonald]

I think that got it. You are life saver
Thanks for the help.

I may have eventually gotten it, but that would have been long after a ceiling fan, short rope , and a broken chair would have been involved.

Now I have to fight access deciding to import the long number skus as scientific notation. I imported longer numbers in the test file, no issue!!!