Large government agency

We were approached by our client who had an urgent need to consolidate data from thousands of spreadsheets for future management reporting.

We delivered a flexible Microsoft Access database - on time, and on budget - to automatically import the spreadsheet data and consolidate it for reporting.

Features included:

• an intuitive user-interface;
• the ability to cope with multiple versions of the spreadsheet forms;
• an easy to follow duplicate resolution process; and
• a mapping function to ensure future spreadsheet versions could be consolidated.