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

Budget $10 - $30 USD
Bids 28
Average Bid $34

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.

Post a Project Like This

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • luisdelgador Profile Picture

    luisdelgador

    Maracay,  Venezuela

    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

    Delphi, Engineering, Mobile Phone, and Excel

  • pforino Profile Picture

    pforino

    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.

    Java, Visual Basic, Project Management, and Accounting

  • gogoulor Profile Picture

    gogoulor

    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

    Research, Accounting, Excel, and Matlab & Mathematica

  • willmansfield Profile Picture

    willmansfield

    Bristol,  Germany

    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/

    Data Processing, Excel, SQL, and Microsoft Access

  • matteip Profile Picture

    matteip

    Latina,  Italy

    • 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.

    PHP, ASP, Visual Basic, and Excel

  • chrisacct Profile Picture

    chrisacct

    Bartlett,  United States

    Specialist in Microsoft Office. Business Services: Data Entry Transcription Database creation/upkeep

    Visual Basic, Windows Desktop, Data Processing, and Data Entry

  • premsl Profile Picture

    premsl

    Udaipur,  India

    OBJECTIVE: To solve complex business problems by architecting and implementing solutions using proven software engineering principles.

    Java, Visual Basic, .NET, and Graphic Design

  • SajjadHussain14 Profile Picture

    SajjadHussain14

    Jhang Saddar,  Pakistan

    Our mission is to provide high quality work especially in Database development, website designing and eCommerce solutions.

    PHP, ASP, C Programming, and Javascript

  • zapataluish Profile Picture

    zapataluish

    Colombia

    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.

    Website Design, Internet Marketing, Data Entry, and Excel

  • workerbee1974 Profile Picture

    workerbee1974

    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.

    Data Processing, Data Entry, Accounting, and Excel