Import Excel worksheet into Access database - Repost with further details - repost

IN PROGRESS
Bids
28
Avg Bid (USD)
$34
Project Budget (USD)
$10 - $30

Project Description:
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.

Skills required:
Excel, Microsoft Access, Visual Basic for Apps
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 103
in 2 days
$ 15
in 1 days
$ 55
in 3 days
$ 35
in 2 days
$ 29
in 3 days
Hire workerbee1974
$ 35
in 3 days
$ 10
in 2 days
Hire jimboyvw
$ 25
in 3 days
Hire pforino
$ 10
in 1 days
$ 15
in 2 days