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

Hi Sam

You have a response for your other post. There is no need to multi-post in
these groups.

http://exceltip.com/st/Export_data_from_Excel_to_Access_(ADO)_using_VBA_in_Microsoft_Excel/425.html


If this post helps click Yes
---------------
Jacob Skaria


"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
>
>