Excel Front End with Access Back End

[Ripan]

Does anyone have any coding samples / tips on the following:

I have an Excel form-based data collection tool. The tool collects
set of data points, performs some calculations and currently stores th
data on an excel worksheet. Ultimately, the tool will need to be used b
multiple people and it would be great if the data be stored centrally s
that people can access and make modifications at the same time. My ide
is that people will have multiple copies of the excel tool which woul
read data for a single entry from the database and when they ente
data, it will either update or add new information to a central Acces
database.

Does anyone have any information or samples as to how to implemen
this?

Thanks,

Ripa

 

[Frank Kabel]

Hi
I would give them direct access to your database