Excel Is The World’s Most Used “Database”?!?!

[psionic2007]

G'Day there,


I found an article from CodeProject that I subscribed that gives me snippets or news of the programming industry and other interests in general. The URL is http://www.codeproject.com/ for interested fellas.


What REALLY caught my eye is regarding Excel and databases, this posting given from CodeProject by Jason Baptiste, here is the URL, you may have to cut and paste into your browser to make it work,


http://jasonlbaptiste.com/startups/microsoft-excel-is-the-worlds-most-used-database/


Enjoy this lighter reading.


Cheers,

Psionic

 

[keymaster]

while the intentions are noble, any product that could replace excel and do what excel does would end up looking like excel :D

 

[cyrilz]

This article is perfectly right anyway :


1. XL is familiar, and easy to set up something. but ...

At this point, the headaches usually start rolling in due to version control.

is something coming regularly and I have difficulties to fight out.

XL cannot do multiuser / concurrency correctly.


Just try to build a SCRUM sheet and share it with your team :-(

 

[Clarity]

psionic,


Thanks for the interesting article.


For me the ideal solution already exists. Hold your data in Access (or equivalent) and use Excel as a front end. That way the data is held in a database tool and the user still gets to use the flexible loveliness that is Excel!


There seems to be a developing understanding that huge amounts of data should not be held in Excel and people are starting to embrase Access.