Update records to existing table in access

[vranjit138]

Hi,

I have three columns A, B and C starting from row 12 in Excel sheet1 - slno, Batch_No,Batch_code

first i get the details of slno and Batch_No. first I update these records in ms access in a table - main_table.
in the evening i get the details of Batch_code. Now i have to update the Batch_code from column C to the relevant slno and Batch_No in main table.

Iam unable to write a update query to update the exising rows of data.

Please help me.

Thanks in advance
Ranjit

 

[Joe4]

First, create a select query that simple identifies the records that need updating. Then, change the query to an Update table, and in the Update To line for the field you want to update, enter the table name/field reference that contain the value you want to put in there.