Hi,

I'm trying to do a basic integration between ODB and another system, based on importing/exporting csv-files. ODB's ID for persons is the master, and the other system knows them. So I have a CSV-file from the other system that looks something like this:

email,ID
email@example.com,1
anotheremail@hotmail.com,2

So I want to update the email addresses of the person with the specified ID in ODB. How do I do that? Is it possible?

If it's not possible out of the box, is it possible to make some sort of extension, or update source code to make this happen? I can write the SQL needed without problem, I just need to know if there's a way I can include that in the import somehow... I don't want the users to have to open Access or run their own queries.

Thankful for any help, or pointers to available resources...