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.
Looking to make some money?
- Set your budget and the time frame
- Outline your proposal
- Get paid for your work
Bids on this Project
I am your requirements Mechanical Engineer, Programmer in various compilers, process control specialist, willing to do for you, which in my power for you to find solution
West Orange, United States
I offer the technical expertise, communication skills, and business knowledge to understand your problem and design the optimal solution. My background includes 10 years in IT within the Financial Services industry, an MBA from New York University (business analytics specialization) and a BA from Rutgers University (major in Management Science and Info Systems). My skills include VBA, SQL, Microsoft Office (including excel / access macros), Database Design, Business Intelligence, and Statistical Modeling.
Tres Rios, Costa Rica
Experience in: Mechanical design, cost estimation, hydrographic survey, Photoshop, 3D modeling, blog edition, process planing, project planning, geographic information systems, finite element method. please see http://gogoulor.blogspot.com
William is well-versed in sourcing, managing, maintaining and utilising business information. He can take large volumes of information and turn then in to evolving business objectives. He is an advanced user of MS Access, Excel, VBA, SAP GUI, SAP B/W, Cognos, Lotus Notes (including Lotus Script) and SQL. He also has a working knowledge of PHP, ASP.NET, HTML and CSS. Establishing healthy working relationships with business partners at all levels, Will ensures he has a good picture of the business so outcomes of analysis can be validated easily, allowing for smother implementation. Pulling these skills together Will can not only produce results for required outcomes, but also assess business need to identify potential improvements and needs not currently address. de.linkedin.com/in/wmansfield/
• Reliability, continuity and dedication to work. • Ability to work to targets • Lead smallgroups working on projects in the short / medium term. • Orientation to problem solving and concreteness. • Good communication skills.
Bartlett, United States
Specialist in Microsoft Office. Business Services: Data Entry Transcription Database creation/upkeep
OBJECTIVE: To solve complex business problems by architecting and implementing solutions using proven software engineering principles.
Jhang Saddar, Pakistan
Our mission is to provide high quality work especially in Database development, website designing and eCommerce solutions.
I am an experienced Entrada de datos Operator and HTML Programmer looking to be hired. I have worked in the areas of Entrada de datos, HTML and Marketing en Internet for many employers and companies around the world I have a strong foundation in these areas. I have also worked as a Arquitectura de software Developer and a Diseño de sitio web Freelancer. If my qualifications are suitable for you, please consider me for your next job or project. I am ready to be hired by you today and start work.
OKC, United States
I have completed my Excel and Access Programming courses for 03,07,10. I am interested to take up the contract of Programmer and I think my qualification will suit the best for that position. I have a vast experience in an array of fields and I accept new challenges. I have a lot of experience as a Excel Programmer and Microsoft Programmer. As I have expert knowledge in Microsoft Access.. I am confident that with so much of versatility I will fit well for your requirement. I am available for hire to work on your projects today.