Excel / Access / FoxPro Sales Analysis

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

Get free quotes for a project like this
Project Budget
Total Bids
Project Description

We have a UK customer with a live Pegasus Opera I accounts system. Pegasus Opera I is written in FoxPro DOS, source code not available, runs on FoxPro database.

This project is to extract Sales Statistics from the Opera FoxPro database and insert into a new Access Sales staistics database. We will need a program that can be run as a scheduled task to copy records from FoxPro to Access every night, only copying new records, and not duplicating records already copied.

There is an existing Excel sales statistics spreadsheet with multiple sheets and columns for each month. The customer currently re-keys Opera sales printouts into Excel each month. This program is to automate the re-keying task using VBA code. It will have to cope with new customers (rows) being added to the spreadsheet and old customers being deleted. The spreadsheet has several sheets.

Don't mind what langauge is used for the program.

We will own copyright in the code and you wil provide full compilable source code.

I wil provide a copy of the FoxPro database and the Spreadsheet on FTP. I can explain where the sales statistics come from in FoxPro and where they have to be entered in Excel.

Windows XP PC

Existing Opera FoxPro database

Program to regularly copy data from FoxPro to Access

New Access Sales analysis database

Existinng Excel spreadsheet to have VBA code added to pull data from Access

Please only bid if you can start immediately and complete in 1 week.

Skills Required

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