Excel spreadsheets are fantastic bits of kit, but databases are not. Rather than making the full jump to replacing Excel with a database system, there is a halfway house you can consider.

Conclusions VBA code dictates what queries user can send to database. Excel connecting SQLite is bulit in the way user doesn't have to know any SQL queries. User can simply retrieve, update and delete ...