MS Access and Excel Integration

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

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

Create a simple excel spreadsheet with data to update the database. This can hold any type of data to be used in this database.

In MS Access

1. Create a form (frmUpdateMediaLink) to link the spreadsheet to a table in the database

2. Create a form (frmUpdateMedia), write a VBA code to extract the data and display it in a listbox, dropdownbox or any from of grid

3. Integrate the spreadsheet data into the application. The spreadsheet should contain new DVDs.

4. Write code to update the inventory DVD table, from the list.

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