Is there an automated way to append a table in Access from a form in Excel? Most of the information on the form is selected from list boxes created from the same Access database, but there is a note field with typed text as well.
Experts Exchange helped me automate the updating process for the Excel form by "Refresh" through "Connections". I am hopeful the process can be reversed some way to get new data from the spreadsheet form into the database without having to type it all in. The same form is used each time with different info in the fields. And it is done many times each week - very time consuming.