excel to access

[db2]

need to send data from excels on 2 or 3 PCs to a remote access database. Like to update the access database as excels get updated. Like to avoid duplicated entries in the access database. Already have the table setup. What is the most efficient way?. any VB code, etc.?. i believe access is 2003 version.

[davide++]

Hi all.

You should explain more accurately your requrements.
What I've understood is that you have an Access database and n Excel sheets, and updating the sheets causes updating the database.
So, a simple solution maybe to link the sheets as table in Access, so when yo add, modify or delete data on sheet the updates automatically are taken in Access.