Embedded Database

Hi

I'm looking for a small footprint embedded database such as SQLite that I could use with my VBScript scripts. It should ideally hold in a single file and shouldn't be too resource hungry on the machine.

Thanks

wat do you wish to store in that database?

I'd like to use the embedded database as a temporary storage for soting, grouping for onward output creatiion. Let me elaborate on my task. I have a VB6 DLL that reads data from a proprietary format and exposes a fabricated ADO recordset. My VBScript script instantiates the DLL, and processes one batch at a time. So what i want is to proceed as follows:

1. Instantiate the DLL
2. Pick up a batch and get a fabricated recordset from the DLL
3. Load the recordset into a work table in my database
4. Repeat steps 2 and 3 until I've read all available batches
5. Use the loaded data to generate summaries, perform groupings etc.

I can of course do this using a standard database like SQL server or Access but I prefer the simple file approach of embedded databases like Sqlite.

Cheers

This sounds that an Application (VB) can better handle this (and would) than VBScript, which is superb in administrative tasks....

Thanks for your input. But I want the flexibility of the script. In the meantime I've found http://republika.pl/roed/litex/automation.html
I'll probably give it a try.