Update database from spreadsheet

[mrobertson]

I have some users who get monthly reports of data from another program into an excel spreadsheet, which correspond to a couple of the customised fields that we have in our accounts module. Does anyone know of a way that my users can update the appropriate records without having to perform manual SQL updates?

[ruchida]

How about using Import ?

[mrobertson]

Import will either create new records or skip them because the id's are the same.

Does anyone have any suggestions on how to change the the functionality of the import scripts so that you can perform large scale updates for particular table fields without having to directly access the mysql tables?