Hello,
so I've got a table with around 40 fields - half of them I want to enter manually using a data entry form which I've already created. The other half already is in a table from Excel, which I've successfully imported. The field names that need to be filled in the original "main" table are identical to those of the excel file I have imported. From what I've read, I need to make a query in order to add data from one table to another - is that correct? There's one field that both tables contain - something like a serial number. What I want is to check for the serial number and if it's the same, add the data that is missing (the other 20 fields who have the same names).
Can anybobdy point me in the right direction?
Thanks in advance!
Octavio