Thread: The best elegant solution to override 65k rows limit in a sheet

I LEFT THAT COMPANY BECAUSE THEY'RE A PIECE OF ****

yes, I was assraped by a demon that ate spreadsheets

this demon lives and thrives in each of your heads.. you sit around and
build the same spreadsheet week in and week out

it is not the most efficient way to do business.

you idiots sit around AND RECREATE THE SAME REPORT WEEK IN AND WEEK
OUT.

YOU SIT AROUND AND MAKE INVOICES IN EXCEL.

YOU SIT AROUND AND MAKE COMPENSATION REPORTS IN EXCEL.

YOU SIT AROUND AND MAKE BUDGETING AND FORECASTING APPS IN EXCEL.

YOU GUYS ARE THE BANE OF HUMANITY-- YOU SIT AROUND AND TAKE ADVANTAGE
OF THE DATABASE PEOPLE-- YOUR DISEASED PROGRAM SPAWNS MORE AND MORE
BEANCOUNTERS-- WHEN WHAT YOU REALLY NEED IS MORE AND MORE DATABASE
PEOPLE.

ACCESS DOESNT TAKE TRAINING.

IT TAKES PEOPLE WITH DRIVE TO GO OUT AND LEARN IT ON THEIR OWN.

YOU GUYS ARE SLOTHS; YOU AREN'T ADAPTING TO TECHNOLOGY. YOU GUYS ARE
JERKING OFF WITH SPREADSHEETS AND YOUR FUTURE CONSISTS OF DRINKING OUT
OF A PAPER BAG ON THE SIDE OF THE STREET.

Harlan-- DATA ENTRY DOESNT EVER HAPPEN IN EXCEL YOU IDIOT.

DATA ENTRY HAPPENS WITH A DATABASE. AND YOUR DISEASED COMPANY AND
DISEASED FRIENDS NEED TO WAKE UP AND SMELL THE COFFEE. THERE ARE
BETTER TOOLS FOR BUILDING THE SAME REPORT WEEK IN AND WEEK OUT. THERE
ARE BETTER TOOLS FOR 'DATA ENTRY'.

Hi,
Put your data in Ms Access then import them on excel by pivot table.

aaron.kempf@gmail.com wrote...
>ACCESS DOESNT TAKE TRAINING.
>
>IT TAKES PEOPLE WITH DRIVE TO GO OUT AND LEARN IT ON THEIR OWN.

Any software can be learned by anyone with sufficient wit, sufficient
motivation and sufficient time. It's that third item that explains why
sensible companies spend money on training - the time saved more than
makes up for the training cost FOR A *FEW* PEOPLE. It doesn't make
sense for *ALL* people, and most Excel users aren't going to spend
their weekends coming into the office to learn Access on their own, and
they're not going to waste their weekdays learning it because they have
their REAL JOBS to do.

>Harlan-- DATA ENTRY DOESNT EVER HAPPEN IN EXCEL YOU IDIOT.

Data entry happens almost exclusively in spreadsheets and two rather
ancient Clipper apps (admittedly database, but xBase rather than SQL)
where I work. You may know how things are done where you work (unlikely
since you'd thoroughly demonstrated your narrowness of perspective),
but you have no idea how things are done where I work.

I can't call you an idiot. That'd imply there was some slight chance
you could recognize the overwhelming stupidity of what you write.

>DATA ENTRY HAPPENS WITH A DATABASE. AND YOUR DISEASED COMPANY AND
>DISEASED FRIENDS NEED TO WAKE UP AND SMELL THE COFFEE. THERE ARE
....

Data entry happens in forms, be they database forms, web forms,
spreadsheet forms, whatever. Maybe most data is stored in database.
That's fine. I'm on record as stating that databases are ideal as
storage subsystems. They make decent reporting tools too. They're just
not particularly flexible for analysis. Of couse if you assume several
tens of thousands of dollars of additional software running on top of
some database, that'd help, but most Excel users won't have such
additional software available for their use, so assuming they do would
only futher establish the utter stupidity of your rants.

YOU'RE NOT IMPORTING FROM EXCEL BACK INTO ACCESS YOU MERELY RUN REPORTS
ON THE NUMBERS

THE DATA ISNT GOING FROM EXCEL TO ACCESS TO EXCEL

ITS GOING FROM THE SOURCE-- TO ACCESS-- AND IT CAN BE ******** REPORTED
ON ***************** through a pivot table.

pivot tables aren't an excel phenomenon.

there are a dozen differenent ways to use pivotTables without opening
excel

I would reccomend OFFICE WEB COMPONENTS over excel any day of the
week.. emailing huge spreadsheets around was passe in 1995

aaron.kempf@gmail.com wrote...
>YOU'RE NOT IMPORTING FROM EXCEL BACK INTO ACCESS YOU MERELY RUN REPORTS
>ON THE NUMBERS

If the numbers aren't in one's company's database, e.g., any
information fresh from customers, Access could do squat all with it.

Possibly it could be scanned and sent through OCR. Obviously we'd
differ on the best software to use to check the scanned/OCRed result,
but I'd use Excel or Word EVERY TIME rather than Access in that
situation.

>THE DATA ISNT GOING FROM EXCEL TO ACCESS TO EXCEL
....

For me, if original data entry is in Excel, it usually stays there,
never moving on to Access or Oracle or DB2. In the rare situations it
does move on to Access, it never comes back to Excel because it's
already available in Excel, and I find it easier & quicker to pull such
data from other XLS files than from Access.

>I would reccomend OFFICE WEB COMPONENTS over excel any day of the
>week.. emailing huge spreadsheets around was passe in 1995

And how would one transmit a lovely OWC object to anyone else if the
sender has no rights to create web pages on the web server, which is
the situation of most employees in most companies whose jobs aren't in
web development? Lemme think - convert it into an Excel file!

When are you gonna stop being an idiot?

When I try to open a large DBF in either ACCESS or QUATTRO,
I get the error message INDEX DOES NOT EXIST.

I am aware that the values in Column A are not unique.

Any solutions?

-- Thanks Jay

I wonder if this Aaron idiot eats with the same mouth that the rest of his garbage comes from?

I wonder what rock he crawled out from? Whatever one it was, he should crawl back under it.

Incidentally, what other names does this moronic troll use to sneak into forums and newsgroups?