Importing Same Records & Updating Fields

[leadpro]

I'm sending out records for people to edit. After they edit, I want to take these records, match them up by ID, and update the appropriate fields to the new data.

?

 

[DotNetGnat]

basic syntax...

UPDATE MYTABLE SET field1='userval1', field2='userval2'
WHERE ID=userID

-DNG

 

[leadpro]

thank you, but I don't think I was clear.

Clients send me back the edited records in excel, I import them back into the same table, or maybe a temp table, then append?

Thanks,
GLO

 

[DotNetGnat]

so lets say you import them to a temp table...now you have to do a update on your original table with new values from temp table...

is that right??

-DNG

 

[PHV]

a temp table, then update

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[leadpro]

Yes to this:

so lets say you import them to a temp table...now you have to do a update on your original table with new values from temp table...

is that right??

 

[DotNetGnat]

ok then you need query which looks something like this...

UPDATE mytable INNER JOIN temptable ON
mytable.ID = temptable.ID
SET mytable.field1 = temptable.field1,
mytable.field2 = temptable.field2;


and so on...

hope this helps...

-DNG