It can be done but it is not simple. You need a good understaning of VBA and
some understanding of ADODB recordsets. We can help you but this is not a
great project if you are inexperienced in custom programming.
--
HTH...

Jim Thomlinson


"sam" wrote:

I dont know if this is the right place to ask this question, but if anyone
could help me with this, would be really great.

How can I auto populate data from excel form into access table.
For eg: I have a form in excel on my shared drive that multiple users will
use to input data, Once they Input data I want to design a submit or a Save
button in the form that would automatically populate the form data into
access table.

Please Help.

Thanks in Advance