You have chosen to sponsor your bid up to a maximum amount of .
I have an Access 2007 database with two tables in which I need to import an Excel 2007 worksheet.
There are a total of four different fields in the Excel file and I do not wish to manipulate the Excel file prior to being imported into the Access database. However, I'm unable to import the Excel file with my current level of expertise. I will send the Access and Excel files to the winning bidder and their job is to accurately import the Excel file into Access while maintaining the proper relational integrity of all entries. I have several Excel files that I eventually will need to import so, I need a solution that will do this seamlessly for me. Ideally, select a button labeled "Import", then select the Excel file I wish to import, and have Access import it into the proper tables all the while maintaining absolute relational integrity with the original data from Excel.
Winning bidder should also take time to explain precisely and clearly how they accomplished the importation so I can understand better about the process for any future needs I might have. The ideal bidder should have an extensive knowledge of Excel, Access and VBA.
Sample files are attached for review along with some further notes.