>
select ExcelCursor
>scan
> select MyTable
> locate for FIELD2 = ExcelCursor.Field2
> if found()
> replace FIELD1 with ExcelCursor.Field1
> endif
>endscan
>
Thank you, Doug. That works and is simple enough for even me to understand. My only problem now is that my database has almost 900,000 records in it, and it looks like this is going to take a very long time to run. Are you willing to share your more efficient way of doing this?
Thanks for all your help.
Dave