Our research tells us that most SME business owners are using spreadsheets to manage their business. And when asked why, they often say that they don't know what else to use.
Before we go any further, spreadsheets provide invaluable tools for collecting and analysing data.They are great for numeric and text values in relatively low volume. However, for very large volumes of data, a relational database has several advantages over a spreadsheet: 1. Data Integrity Access to a spreadsheet is often limited to one person at a time. Relational databases are designed for multiple users and when one person makes a change, it is visible to everybody instantly. This feature preserves data integrity and data consistency, which is harder to manage when using spreadsheets.