Best practice to use MS Excel as a database
- by Ying
In office, it is popular to use MS Excel to store data. In most cases, the data is structured, which means it is suitable for a database.
I know peole prefer MS Excel for it is easy to change the data structure and data value.
So I have an idea to use MS Excel as a database IF people follow a general rule to store data. In other words, by a best practice to use MS Excel as a database. I have thought to use MS Access to store data, but it is expensive and not popular as MS Excel.
I don't mind to buy such a solution, especially when it is for .Net platform.
Any ideas or suggestions are welcome.