connect excel form to access table

  • Thread starter Thread starter sam
  • Start date Start date
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
 
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

access table connected to excel form 3
connect excel form to access 1
auto populate data from excel form to access database 3
auto populate access database from an excel form 1
Dynamic Excel data into locked Word form 0
Access Form Refresh 1
Data Entry Form 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top