D
dede
I do have two table.
One comming from Excel (Link Table) which need to "update" an other table
"A" with two field (CRA_N° & ch_N°).
(Table "A" have a autonumber as primary key).
But
Excel will be udated as well (externally) and I will only append the new
data from excel (to avoid redundancy)
In addition for each excel line imported, I will add in my Table "A" under
Status field "reserved "
could you tell me how to do that in my append query ?
One comming from Excel (Link Table) which need to "update" an other table
"A" with two field (CRA_N° & ch_N°).
(Table "A" have a autonumber as primary key).
But
Excel will be udated as well (externally) and I will only append the new
data from excel (to avoid redundancy)
In addition for each excel line imported, I will add in my Table "A" under
Status field "reserved "
could you tell me how to do that in my append query ?