Excel Is The World’s Most Used “Database”?!?! « Chandoo.org - Learn Excel & Charting Online

Chandoo.org - Learn Excel & Charting Online - Forums » Ask an Excel Question

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

(4 posts) (4 voices)

Started 2 years ago by psionic2007
Latest reply from Clarity

Tags:

psionic2007

Member
Joined: May '10
Posts: 5

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

Posted 2 years ago #
Chandoo

Key Master
Joined: Jul '09
Posts: 585

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

Posted 2 years ago #
Cyril

Member
Joined: Jul '09
Posts: 82

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 :-(

Posted 2 years ago #
Clarity

Member
Joined: Dec '09
Posts: 72

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.

Posted 2 years ago #