delete query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have a table I need to update.I plane on importing my spreadsheet to
the table. If I have a matching record, what is the best way to put the
vewest data into my table?

Hope I explained this ok
 
coconutt said:
Hi, I have a table I need to update.I plane on importing my spreadsheet to
the table. If I have a matching record, what is the best way to put the
vewest data into my table?

Hope I explained this ok
Click to expand...

coconutt,

Untested Aircode:

UPDATE ExistingTable AS ET1
INNER JOIN
ImportedTable AS IT1
SET ET1.Col1 = IT1.Col1
,ET1.Col2 = IT1.Col2
,etc.
,etc.
WHERE ET1.PK = IT1.PK

Note: This is only an example meant to point you, potentially, in
the correct direction. It is not the actual query you will run.


Sincerely,

Chris O.
 
Back
Top