DevonAgent to open and scan zip archives

At least the first two steps should be scriptable, the last one probably too if Excel is installed on the computer.

What kind of database/frontend do you have in mind?

Finally, this thread might be useful too: