[AccessD] OT: Survey

Now, now, Darryl, remember your blood pressure. LOL

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl
Collins
Sent: Monday, November 17, 2008 3:05 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] OT: Survey


My experience with Excel and the common user is that most of them cannot
use 65535 rows of data in a way that doesn't cause Excel to grind itself
into a sreaming bloody mess, Excel 2007 can calc even slower so I  am
very sceptical about the benefit of more rows.  It is just going to
encourage bad design where the input data and output result are
indentical.  Where you get massive volumes of data, hard coded into a
fixed report, spread out over time, rather than tabulated and reported
via pivot tables.

My god, can you imagine trying to Audit something like that???  What the
hell where they thinking?

If you have a million rows of data, put in in SQL Server or similar and
pull into excel just the data you need for your analysis.  A spreadsheet
should be a reporting and/or analytical tool,  not where you store your
source data.

I think MS have lost the plot. They have forgotten that Excel is a
spreadsheet and Access is a database and tried to make them both into
this bastardised hybrid monster.  Frankly I think they have made both
products worse, not better.

bah, I must be getting old and grumpy - I am sounding like a luddite!!

If it wasn't VBA I would have given up on MS Office and gone to OO
instead a while back.
<dismounts off high horse>
~time~for~a~coffee~
cheers
Darryl.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gary Kjos
Sent: Tuesday, 18 November 2008 9:08 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] OT: Survey


You can have 1 million rows in an Excel 2007 file verses approx 65K in
an Excel 2003 file.

That alone would make me want it if my company allowed it.

GK

On 11/17/08, Stuart McLachlan <stuart at lexacorp.com.pg> wrote:
> So tell me, what could I do in Office 2007 that I can't do with 2003?
>
> Can anyone give me a compelling reason to upgrade?
>
>
>
> On 17 Nov 2008 at 9:55, Susan Harkins wrote:
>
> > It does appear that people are slow to upgrade this time -- more so 
> > than any other that I can remember.
> >
> > Susan H.
> >
> >
> > > Not ignoring you.. just only use A2007 at home on a very limited 
> > > basis. We still ise 2003 version at work with no plan to move..
> >
> > --