[AccessD] OT: Survey

haha. I guess I'm not the only one that feels this way :)

On Mon, Nov 17, 2008 at 3:29 PM, Charlotte Foust <cfoust at infostatsystems.com
> wrote:

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