Hey guys,
I'm working on a database project as an intern and was asked to create a simple database. I know a little bit of VBA coding (not a WHOLE lot) and I was wondering if their was some pre-existing code that automatically, when I click a button in a form, allows the user to select the worksheet and file that he/she would like to import data from (Excel file that is) and automatically grab the data from a certain cell range and place them in their appropriate fields in Access. Where would I put this code into?