Message Font: Serif | Sans-Serif
No. of Recommendations: 1
I was thinking the same thing. Excel is OK for faking an RDBMS up to a point, but it has a lot of potentially bad behavior ... behavior that is very handy in some non-relational problems, but is bad behavior from a relational point of view. It could be you would actually be better off in Access.

Excel is fundamentally a glorified calculator. A powerful one, for sure, but a calculator. Using it for complex data management is asking for trouble. A lot of people don't understand the basics of RDBMS and so stick to Excel because it is what they know.
Print the post  


Live Video Event Monday!
The GP team is hosting a live video event on Monday at 4 p.m. ET. Don't worry if you can't make it — we'll have a replay and a transcript. Click for more!
When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and Glassdoor #1 Company to Work For 2015! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.