Re: The best elegant solution to override 65k rows limit in a ***

aaron.kempf@xxxxxxxxx wrote...
>you still haven't told me how it is that you somehow dont recreate the
>whell 10 times a month
>
>YOU BUILD THE SAME SPREAD*** EVERY WEEK

No, you just want to believe that.

I use the same spread*** templates several times a day, but only the
data changes, and the data comes from outside my company, so the only
electronic feed is from e-mailed PDF-to-clipboard-to-Excel. (Actually,
e-mailed PDF to pdf2txt to awk to CSV to Excel, but why quibble?)

The new workbooks I create each day typically involve fewer than 100
entries, of which usually fewer than half are formulas. In other words,
I use Excel like an overgrown calculator. If you think Access is
anywhere near as efficient as Excel for this sort of ad hoc
calculation, you're stupider than you've already proven.

>i mean YOU GUYS CREATE THE SAME REPORT EVERY WEEK

No, you create the same report every week. We do real work.

>Excel is dead; and I hope that you Excel dorks are all kicked to the
>curb.. you guys think that you're so good with numbers.. i mean.. WAKE
>UP TO REALITY and either learn Crystal Reports of Microsoft Access.

What makes you think we don't already know these other systems? What
makes you think we don't use them when *WE* believe they're more
appropriate? We just don't use them to the exclusion of anything else,
which seems to be your (so-called) mindset.

>EXCEL SHOULDN'T BE USED FOR DATA ENTRY YOU DORK

To some extent you have a point. Excel isn't ideal, and I don't use it
all that much except for small datasets (<100 entries) or when I have
to enter tabular data I receive in hardcopy (depressingly still not an
infrequent situation - we have a scanner in my department, but no OCR
software - sigh). When possible, I use awk scripts to parse text files,
even text files generated from PDF files.

However, most people don't know scripting languages, so they're stuck
using the tools *THEY* find easiest to use. The world has voted: Excel
is easier to use for data entry. Live with it!

>Excel doesn't store data; it stores spaghetti code and millions of
>different functions

If used in an undisciplined way, true. If used properly, false.

There are a lot of people who claim programming in Assembler (or C) is
pure evil, but Assembler (and C) can do more than anything else. They
can be used badly, but they can also be used well. It takes a lot more
discipline to use them when than, say, VB, but once it becomes a habit,
they're easier to use. Same with spreadsheets vs databases for the
things the rest of us understand are easier to do in spreadsheets. You
don't have a clue what those things are because you only seem to know
how to generate reports. Report generation really isn't the only thing
people use computers to do.

>aren't you tired of changing formulas in hundreds of different cells?

Depends. But on the other hand I'll take formulas over stored query
results when typos or other errors are discovered in some base table
that require hundreds of queries to be rerun.

>there is a better way; it is called ACCESS or CRYSTAL REPORTS.

For generating reports, agreed. For doing real work, you're full of it.

.