Update/Insert query

[Poptartme]

I want to update Override field in Table 2 using Qty column in Table 1. How do I write this query? Thank you!!!


Please see attached tables.

 

[khawar]

On what basis you want to update field there are to many matching fields in both tables

 

[Poptartme]

based on Item no. If the item numbers in two tables match, then update Table 2.

thanks!!

 

[khawar]

Again there are lot of value for the same item no in table1 which value you want to update

 

[Poptartme]

Actually, I want the QTY column go into override column. That's all I want.

Basically, I have Excel data in the format shown below. And I want this Excel data to replace overide column in ACCESS table. How do I set this up in ACCESS so I can write a query/macro in ACCESS that does the update/insert in ACCESS?
EXCEL DATA
ItemNo aug sep oct nov dec jan feb
102C 100 150 200 190 290 500 450

ACCESS TABLE
ItemNo Override
102C 100
102C 150
102C 200
102C 190
102C 290
102C 500
102C 450

Thank you so much!!

 

[khawar]

If you fill the column override in the excel sheet you attached with the value you want in all columns then may I will be able to understand else I am confused

May be some one else understand what you ant