Use "linked tables" in Access, any changes made to the SS are automatically
updated in the DB.

P


"Mike" wrote in message
...
Hi all,

I've got a number of users that have excel installed on
their PCs, but not Access. I would like to start an
Access database that these users can read from (queried
through Excel) and write changes to the database. I can
import the data no problem using Microsoft Query, but is
there a way to update the tables in the access database
using only Excel?

Any tips or points in the right direction would be
greatly appreciated,

Thanks in advance,

Mike