What DBMS should I use for a simple extraction problem

[paulreilly]

Any help appreciated! I am putting together a solution to extract customer data from a data file, re-format it, and then send it to a 3rd party for further processing. The DB file is in .mwi, .mwd format. The processing is pretty simple, just search on certain fields, filter on dates & times, clean up phone numbers by removing zeros and so on.

Ideally the solution should be easy to run, so that, say, the receptionist can run it every night.
I was thinking of writing this in vbscript, but a) vbscript is not for beginners! and b) it will be difficult to maintain.

Is there a right dbms that is easy to set up to do this, and also easy to run? (And I don't really want to have to install 22MB of mySQL into the target machine.....).

 

[Dimandja]

Try Microsoft Access. Easy and common. It's probably already installed on the target machine.

Dimandja

 

[ArkM]

Export data in CSV (txt with field separator) format and use any language (from Basic to C++) to filter CSV output by simplest console application. I think, 3rd party receiver can import the CSV result for further processing. It's platform-independent solution in spirit of 'divide and power' slogan. It's the fastest solution too. Wrap in shell script for easy use. Ask any minimal skill programmer friend to write this utility if you can't.

 

[paulreilly]

Thanks, guys! i'm going to try a mock-up with both Access and VBScript, and see which one will get me on the air fastest - Here goes with "Learn vbscript in a weekend"!
Paul