Re: Replace / update a large number of records

use sql udpate ?

On Fri, 22 Feb 2008 19:21:01 -0800, Eddy <Eddy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I have about 500 records in table_a (field name : partno, location)
I want to update/replace the location field in master file (about 10000
records) which has the same partno in table_a
please, give me a hand, what is the better way (or fastest way) to do this.
thank very much.

.