Access Forms - and Excel

P

pfaith

How can I use an access form to feed data to an Excel worksheet? Is this
possible? OR...
How can I create a form separate from my database. I don't want users to
have access to my table/database, just the form so they can enter data?

I am new to Access. Thanks for any help.
 
M

Mark via AccessMonster.com

You can link an Excel sheet just like an external database table and treat
it like a table. You can base a form on the table and interact with it.
The columns of the spreadsheet are your fields and the rows are the records.
 
Top