Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

February 2009 - Nick Hodge's Excel Blog

  • Today's Large Data Set

    Now, since Excel 2007 was announced to be having over 1 million rows, I made the statement, "Be careful what you wish for". Excel is not a database, there are programs far more suited to that task such as Access, SQL Server, SAP, Oracle, etc. Excel is a great reporting tool for those databases and can do fast and quite complex calculations much better than a database can. What I am conceding more and more now though, is that as my familiarity with Excel is far greater than with SQL Server...
    Filed under:
Copyright Excel User Group and the relevant contributors, 2009. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.