Importing CSV files into tables and Updating

[naveen327]

Hi I have imported two different CSV files (A.csv and B.csv) into two different tables (tbl_A and tbl_B) respectively using a VBA Import function.

My problem comes when I am trying to update a col_product (which is empty) in tbl_A with data from col_product in tbl_B on a inner join between column concat in tbl_A and col_concat in tbl_B.

My update query looks like this
UPDATE tbl_A SET tbl_A.Product = (SELECT tbl_B.Product
FROM tbl_B INNER JOIN tbl_A ON tbl_A.Concat=tbl_B.Concat);

The select subquery within the update returns 488 rows with the products but when I run the update query it shows 488 rows which are blank?

Note: Should I be telling the update query exactly which rows to update on in tbl_A?

Any help would be much appreciated.
Thanks, Naveen

 

[wongm003]

Hi Naveen,

It sounds like you want to update the Product field in tbl_A with the value in the Product field in tbl_B where the concat fields from both fields are equal... if so, you would use:

UPDATE tbl_A INNER JOIN tbl_B ON [tbl_A].Concat=[tbl_B].Concat 
SET tbl_A.Product = [tbl_B]!Product;

hope this helps.