| Author |
Topic |
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
 Posted - 2005-05-06 : 11:29:35
|
Warning...Warning Will Robinson. Imminent Rant Detected.“I have my data stored in the database, its right here on this excel spread sheet."I would like to choke all the instructors that refer to excel as a database.I cannot believe the number of times I have had to explain this to people.Then there is the second part "Well I can do it on my spread sheet!" JimUsers <> Logic |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-05-06 : 12:12:50
|
| Hey, there are somethings that Excel, well , excels at.Like Access (or any other tool for that matter) it can be well abused.For example, another consultant built this monster...34 tabs, over 20,000 formulas ( I know because I wrote som vb to extract all the formulas, with their tab and cell refernce to a delimted file. So I could load it to a table and do some analysis..they needed help to dociment what they built because of SOX....what a mess...My pet peeve..that the call Notus Lotes a database...I hate notes...Brett8-) |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-05-06 : 12:25:24
|
Excel as a databaseI know I posted that before, but it so funny  rockmoose |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-05-06 : 12:48:34
|
| I have begun to use the example of I can create a million dollar paycheck using illustrator,But I doubt the bank will cash it.JimUsers <> Logic |
|
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-05-06 : 14:07:27
|
| I swear whenever we are starting with a new group when they say "we keep our data in an access database" a certain part of me puckers very very tightly. I almost prefer the ones who use excel because they don't think they know databases(usuaully). Try convincing someone who only knows access that it's not the best thing in the world and watch the sparks fly.Mike"oh, that monkey is going to pay" |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-05-06 : 14:22:15
|
BAHAHAHAHAHAHAHAHAHAHmoose that really was funny, (wiping tears right now).You guys think that is bad...I have worked with this german company for about 4 years and they have been using this ENORMOUS (sounds like brett's app) 50+ tab excel workbook ironically called, the kalculation database. This thing has been nothing but a nightmare from the get go. And each day a new tab is added and 50 new macros....talk about denormalized...If anyone wants any tips of how to denormalize a database then come work with us!!!! We'll even put it in the EXCEL database!!!!!!
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-05-06 : 14:25:28
|
| See that's why I like SQL Team. Whenever I think I work with stupid people, there's always someone who has it worse and I can move on. Sounds like a piece of krap.Mike"oh, that monkey is going to pay" |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-05-06 : 14:29:48
|
They aren't stupid, remember we are always considered the peons.Its always your fault, even if you are right.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-05-06 : 14:47:21
|
| Our customers receive data from us, and almost always want it in Excel.We have one customer that gets a daily one with 150 tabs on it that is about 45 MB in size. It has extensive formatting on each tab, as required by the customer, and no one can figure out why it takes 10-15 hours to create.They asked me if it was a SQL Server issue, and I showed them that I could run all the queries required in about 15 minutes. I think they don't really believe me, and suspect some DBA trickery.CODO ERGO SUM |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-05-06 : 14:48:47
|
Ahh yes, memories, again its your fault..they prolly look at you like you are lying...
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-05-06 : 17:30:30
|
They may suspect I'm lying, but they know better than to say it.My retaliation would be swift and unmerciful.  quote:
Originally posted by jhermizAhh yes, memories, again its your fault..they prolly look at you like you are lying...
CODO ERGO SUM |
|
|
|
|
Excell Database