For some reason, I need to combine some data into one access database. I can think of two ways to do it, but don't know exactly how to do it. hope someone can provide me some advice and suggestion.
first, I can send a copy of the database from my office (A) to another office say (B), and when people finish filling up their data into the table, send back the database and I combine the two table together.
Second, or I can ask office B to send me a excel file with all the data I required and I import them into the database.
however, the difficult part is while office A is filling up the database or the excel file, I cant hold the people in my office to fill up their data as well.
there is a concurrent issue here. In another way to explain is the primary key may be generated by office A or B first, for example, A need to fill the information about a product's price and description. while B needs to fill that product's other attribute like size and weight. How do I combine these information in bulk?
I know how to import data from excel to append access, it is simple there is no duplicate primary key but how do I update data if it is already in the table?
Thanks for any help in advance.
first, I can send a copy of the database from my office (A) to another office say (B), and when people finish filling up their data into the table, send back the database and I combine the two table together.
Second, or I can ask office B to send me a excel file with all the data I required and I import them into the database.
however, the difficult part is while office A is filling up the database or the excel file, I cant hold the people in my office to fill up their data as well.
there is a concurrent issue here. In another way to explain is the primary key may be generated by office A or B first, for example, A need to fill the information about a product's price and description. while B needs to fill that product's other attribute like size and weight. How do I combine these information in bulk?
I know how to import data from excel to append access, it is simple there is no duplicate primary key but how do I update data if it is already in the table?
Thanks for any help in advance.
