delete query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

coconutt - 09 Nov 2005 17:35 GMT

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

Reply to this Message

Chris2 - 10 Nov 2005 00:39 GMT

> 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,

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.

Reply to this Message