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.