STORE YOUR EXCEL DATA IN AN SQL DATABASE
Increasingly, it occurs that our customers’ needs can best be covered by a solution in which Excel is combined with an underlying database. That, for example, can be due to large amounts of data, a wish for simultaneous access by several users, or increased security. In such cases, a combination of Excel and a SQL database ought to be considered as a part of the solution.
We have developed a technology which enables you to keep your Excel-based data in an underlying SQL database. The technology simply requires that the data can be collected in a consistent way, for example, via one or several standardized Excel templates. There are no limits on how these Excel templates are framed. That is to say, you achieve the advantages through Excel’s flexibility and the database’s data integrity and data sharing functions.
Advantages when combining Excel with a database solution
- All data are kept in a secure SQL database where several users can access data at the same time. Thus, you avoid the need to distribute data in several Excel files.
- Possibility for management of file versions and access via database rights. Thus, there are no users who can access data they don’t have the rights to, just as it is not possible to use an incorrect version of a given file.
- The SQL database can easily be integrated with, for example, an ERP system, with which you get the opportunity for automatic updating of the Excel solution with realized numbers from the ERP system.
- In case of large amounts of data and high complexity, computations can be made directly on the SQL server, which provides a calculating power and speed many times greater than what is possible in Excel.