connect excel form to access table
 

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

connect excel form to access table
 

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

connect excel form to access table
 

Refer the below link.

http://exceltip.com/st/Export_data_f...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