access table connected to excel form

  • 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
 
<aybe you're a step ahead of me on this but......

A form is just a window to the data.

-An Excel form is the window to Excel data
-An Access form is the window to Access data.

Why not just use an Access form?
 
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
Click to expand...

I would suggest you just link the excel file. Once linked, you can use
it just like a regular table, there is no need to copy it into a
"real" table. In the moment your users input data into the excel file,
it is reflected in your database.

Hope this helps
 
Hey Fred, I cannot use access form becasue there are a lot of people who
would be filling the form who dont have access installed on their machine.

Saumin
 
Back
Top