There are environments where Excel is used as glue that does faux-ETL for very unpredictable data which is so small in volume you don’t even consider a database. Also, database would mean MS Access which is just icky so it was used only when necessary.
At that point you should just use a database.
There are environments where Excel is used as glue that does faux-ETL for very unpredictable data which is so small in volume you don’t even consider a database. Also, database would mean MS Access which is just icky so it was used only when necessary.