Excel / Access / FoxPro Sales Analysis

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: .NET, Visual Basic

See more: access excel dos foxpro, insert access foxpro, sales analysis excel, we excel, visual foxpro source code, source for visual foxpro, sales re, in visual foxpro, $ in visual foxpro, excel &, data analysis with excel, access, sales analysis system foxpro, opera database foxpro access, copy certain records foxpro excel, read records foxpro insert access visual basic, excel foxpro, excel access foxpro database, pegasus opera database, pull data foxpro using project

About the Employer:
( 2 reviews ) Shrewsbury, United Kingdom

Project ID: #113614