Hello, what I've been doing in Access is manually typing out the info from Excel into a form so it will go into the Access table and appear in a new record on the form.
I know how to bring in the data from Excel into the Access table, but when I bring in the data it only appears in the table. I want it to create a separate entry in the form as well. This is because the users managing the data don't look in the table (only in the form). Is there a way to do this?
Could I do something like make a button on my form that, when pressed, will populate the forms fields from the Excel sheet?
Thank you,
Brad