connect excel form to access table

S

sam

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
 
J

Jim Thomlinson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

connect excel form to access 1
access table connected to excel form 3
auto populate data from excel form to access database 3
auto populate access database from an excel form 1
Access Form Refresh 1
Dynamic Excel data into locked Word form 0
Getting information from access table in excel 1
Data Entry Form 3

Top