2010/1/1 Andreas Saeger <[email protected]>: > Dotan Cohen wrote: >> >> any of the issues belong to different projects, most of which I am >> not the only member of. Although I have no fear of databases, it seems >> that Excel has many database-like features > > The database-like features *assume* database-like structures without > enforcing them by any means while most users are not aware of any such > assumtions. > It is completely up to the user if your table is properly normalized with > valid, complete and unique items (not to talk aboutreferencial integrity). >
Many of the items are not unique nor need they be for the task at hand. I could add an ID column, but that is not the problem here. >> I know that this is not the ideal answer, but it is the reality of the >> situation. Either Calc or Excel, and I need to say thanks that it is >> Calc. >> >> > > Well, yes. No professional IT person will ever use a spreadsheet as > database. Are you kidding? Professional IT is the laziest profession, by definition (read Larry Wall). Who isn't using Excel to store data when external access and integration is not an issue? > There are dozends of practical reasons why countless programs may > export results to Excel but never store and organize data in such documents. > The vast majority of Excel users wants nothing but _quick results_ and Excel > serves them badly. While it is easy to get any results, it can be extremly > difficult to get _correct results_ from such document based storages. I have > never seen any reasonable argument why spreadsheets should be used like this > (except for mere laziness). Don't discard the desire (or need) to reduce one's workload as a valid reason. > Base may be the worst database app on the planet, but it is so much better > for the simple things that most people desperately try to do in the wrong > application, I agree 100% -- Dotan Cohen http://what-is-what.com http://gibberish.co.il --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
