I have created a form in Excel. I would like to be able to allow users to
fill out the form, have that data link to an Access database and then have a
clear form for the next user. I downloaded a template wizard from Microsoft
that allows you to create an Excel template and link the template to Access,
but once you have filled out the template, only that specific data links. I
tried creating worksheets using the template, but that does not work as it
does not link to the Access database. Any suggestions?