Large Data Updation (1 Viewer)

[Drunkenneo]

I have a table in database, with pk as internal no and in normalised form.

Here user will import an excel with the information having internal no, my task is to match the internal no and update the required row with the data.

How ever i can do it, by running set of queries, i want to know if there any more quicker side, where u can compare first the entries and not matching then update, yes it will be the case if blank also there.

any help

 

[Anakardian]

What I have done is to import the data into a temporary table.

I have an additional field in the table which is a yes/no field.
I first run an update query on the temporary table where I mark all existing data with the yes/no field.
Afterwards i can then append all data that is not already included.
Once I am done, all data in the temporary table is deleted.

I am sure you can use the same technique to check for data that needs to be updated and then update it after you have identified it.