Jim,
I have experience with that sort of application.
In one case I have a C# program that downloads share data from a certain
site. One file per day in CSV format. The format of the file has
varied over time so the program does some cleansing. The raw data is
then loaded to a database where the heavy duty work starts.
Doing something like day to day deltas and producing a report or data
extract to be distributed is easy from there. My main product is a
database query and reporting tool that can work on pretty much all DBMSs
/ data sources (including Excel (.XLS) and .CSV). It includes a script
language suitable for automating exactly this sort of process. Results
can be produced in various formats including Excel, CSV and PDF. An
email script command can send results out.
Give me some sample data (say 3 days worth) and I'll mock something up.
Don't know if a custom application or the general purpose tool is the
way to go without seeing some data.
I have done things like this in Excel using VBA. C# or VB.Net are so
much richer that I wouldn't contemplate using VBA any more.
Regards,
Paul
Post a reply to this message
|