Read and process a sql databse file to an excel file
$30-5000 USD
Completed
Posted almost 12 years ago
$30-5000 USD
Paid on delivery
I need a Windows program that will collect a sql database file, from a remote FTP device. The file will always be in the same location and have the same name on the remote device. The FTP IP address, username and password will need to be configurable on a settings page. The setting page should also have an option to set a time to collect this file. E.g every 24 hours. It should allow for upto 16 different FTP remote locations to be setup to collect files from.
Once the file is collected, it needs to be processed, inside the database file, there is a table, with several column's, data from some of these column's needs to be read and wrote to an excel file (maybe CSV). It should also add the totals of some of the column's.
I have a sample file, that can be supplied, if you need to see before bidding.