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.
28 freelancers are bidding on average $34 for this job
Dear Sir, I'm interesting in your job. I have much experience in the MS Excel and VBA. I can do this job. Regards. PS. In order to show my ability, I can send my sample files to you.
I have projects with VBA (Excel and Access) since VWorker. Should you consider me to do the job, will assure you that you won't get disappointed. Have a nice day ahead!
I've done several projects in ms access. and i really have expertise in excel please see [url removed, login to view] Please sent a test problem to test my skills. Best regards
my current's job is export data from access DB, handly the data, and import the data back to DB. according the project description, I can finish you request very easily.