Updating Data From Different Users

[Oraclesoft]

Dear all ,

i am maintaining a Access 2007 database for a customer. I have tables, queries and some modules. i have to generate query results and give it to the customers every week. as input i am importing excel tables.

Now the problem is ,
i have generated a query result and exported as excel file, that will be handed over to around 5 people. everyone will change the data in a single particular column and all of them will send me the files back. Now i have to updated the changes made in the 5 copies of this excel file and import it into the database again. How should i do it in the best way? i am afraid to overwrite the changes made by each other and in the end just left with the changes made by only one of them..
Please help

Best Regards
Oraclesoft

 

[Oraclesoft]

any ideas?

 

[MikeLeBen]

I assume you have your table/s properly set-up to accept data of the kind you're expecting to.

It all depends on how you want to discriminate among, say, who provided that data after an import.
You're not providing much information as to how to help you. You need to circumstantiate, provide context, possibly examples or code snippets.

Please check this thread, too.

Help us help you.