I created a template in excel that matches the layout of a form I have in my Access Database. The reason for this is we can export all the data of one record into the template, email it to someone, that someone can fill in whatever portions they need to fill in and send it back.
This is where I'm running into trouble, the next thing we need to be able to do is take what has been emailed back to us and import the excel fields that have been filled in (they are pre-defined) into our Access form. I have found plenty of codes for importing data, but they make you import the entire excel file. Could someone help point me in the direction of a code that lets you set pre-defined fields in it to import from Excel?