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
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.
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online