Excel to Access

This project received 17 bids from talented freelancers with an average bid price of $125 USD.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Total Bids
Project Description

I have a bunch of excel files and I want to combine them into one database in access.

As you can see, there are 3 files below that I want to integrate into microsoft access 2007.

The file 5.2 TEST will have all of the data from 5/1/2012. Inside, you will find several sheets, but the important sheets are Phones and Accessories. In the sheet Phones, you will find a range of table. The blue color indicates incoming phones from supplier that are still in warehouse untested. The green color indicates what phones are left in testing room. The orange color indicates overall phones left. The purple color indicates what phones are being sold today, backdoors packed with the phones. The Accessories sheets contains the number of accessories overall and what are being sold today, and the formula is gotten from the count file. Explanation about the formula: if phone A and phone B are being packed and shipped, the battery and charger and boxes and envelopes are being deducted according to count file.

The file May 1 - new count will have all of the data from the testing room on 5/1/2012. The file contains what phones are currently being tested, pass as new, pass as used, pass as refurbished etc.

The file count will have the information about the item

What I want to do is to create a microsoft access database in which I can monitor the data in 5.2 TEST and May 1 - new and create a report based on what items to order next, how many items to test next.

Looking to make some money?

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

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online