[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..
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


--
Gary Kjos
garykjos at gmail.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

This email and any attachments may contain privileged and confidential information
and are intended for the named addressee only. If you have received this e-mail in
error, please notify the sender and delete this e-mail immediately. Any
confidentiality, privilege or copyright is not waived or lost because this e-mail
has been sent to you in error. It is your responsibility to check this e-mail and
any attachments for viruses.  No warranty is made that this material is free from
computer virus or any other defect or error.  Any loss/damage incurred by using this
material is not the sender's responsibility.  The sender's entire liability will be
limited to resupplying the material.