access table connected to excel form

[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

 

[Fred]

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

 

[Joe]

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

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

 

[sam]

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