I need to dump selected tables from 3.71 to a more easy to work with database format.
I would like a utility or set of scripts that can be run on a local server to populate a mySQL database for PHP based reports and extracts.
My managers need reports that are too complex and unstable to be coded in Crystal and much too complex for VI.
I currently use Excel to extract the data from selected tables then import the data into a Visual Foxpro 9 database. This is not and easy process and much to manual for daily processing.
Is there a packaged tool or a good whitepaper on doing this type of process? I would prefer to have all of it run as a PHP script on the webserver but would accept any viable solution.
NOTE: Management has given me NO budget to do this on so cost IS an issue!
Jon
I would like a utility or set of scripts that can be run on a local server to populate a mySQL database for PHP based reports and extracts.
My managers need reports that are too complex and unstable to be coded in Crystal and much too complex for VI.
I currently use Excel to extract the data from selected tables then import the data into a Visual Foxpro 9 database. This is not and easy process and much to manual for daily processing.
Is there a packaged tool or a good whitepaper on doing this type of process? I would prefer to have all of it run as a PHP script on the webserver but would accept any viable solution.
NOTE: Management has given me NO budget to do this on so cost IS an issue!
Jon