Results 1 to 8 of 8
  1. #1
    Full Member jollygoodpirate's Avatar
    Join Date
    January 18th, 2005
    Location
    NC
    Posts
    227
    Latest Excel Supports 1 million records instead of 100,000
    I've just read about this on this blog:
    http://www.monetisethis.net/2007/01/...ut-to-get.html

    I know many people here use Excel to manipulate Datafeeds, and the truly large ones always give you problems because excel only supports 100,000 records per file... well it seems like the newest version can handle over 1,000,000 records, so you'll be able to handle just about all datafeeds.

    Success to All!

  2. #2
    Affiliate Manager MINDsprinter's Avatar
    Join Date
    August 18th, 2006
    Location
    Washington, DC
    Posts
    1,436
    Good good news, though I'm not sure I want to shell out the cash for another upgrade...

    Plus the learning curve...
    Jason Rosenbaum
    Affiliate Manager
    MINDsprinting

  3. #3
    Newbie
    Join Date
    July 1st, 2006
    Location
    NJ
    Posts
    11
    Quote Originally Posted by MINDsprinter
    Good good news, though I'm not sure I want to shell out the cash for another upgrade...

    Plus the learning curve...

    Thought I would pass this along. I just went to a launch for Vista / Office 2007 and they are giving out Office 2007 for free.

    http://www.microsoft.com/business/la...p/default.mspx.

  4. #4
    ABW Ambassador PatrickAllmond's Avatar
    Join Date
    September 20th, 2005
    Location
    OKC
    Posts
    1,219
    IF you are touching that many records you need to seriously consider learning a programming language. And I don't care which one. At least do yourself a favor and learn the VB scripting language that is behind Word, Excel, etc. At 1M records you really need to stop using excel. You are using at as a database management tool, and that is not what it is designed for.
    ---
    This response was masterly crafted via the fingers of Patrick Allmond who believe you should StopDoingNothing starting today.
    ---
    Focus Consulting is where I roll | Follow @patrickallmond on Twitter
    Search Engine Marketing | Search Engine Optimization | Social Media | Online Video

  5. #5
    http and a telephoto
    Join Date
    January 18th, 2005
    Location
    NYC
    Posts
    17,708
    I wouldn't use it for a million records, however for a couple hundred thousand its nice. And to just open the feed and see how its organized, it is nice too. You don't always know how many records there are before you open a file
    Deborah Carney
    TeamLoxly.com BookGoodies.com ABCsPlus.com

  6. #6
    Affiliate Manager
    Join Date
    January 17th, 2007
    Location
    NY
    Posts
    191
    Good to know, we often manipulate large data files and sometimes hit the excel threshold. I'll have to upgrade.

  7. #7
    Classic Rocker Mack's Avatar
    Join Date
    January 27th, 2007
    Location
    Lower Left Coast
    Posts
    1,167
    I just played with it and it works well. Dropped in a feed with 300k items in it, did some fooling around with it, was ok.

    Not the fastest thing in the world to do. On my 3.4Ghz/2Gb ram machine it was still a little clunky, but it worked.

    The new office is ok. To me it looks more like a browser now than the old program. It's all very blue. I'm sure I can change the color but there's too damn many buttons everywhere.

    I'm about to get brave and try the new Outlook.

  8. #8
    Affiliate Manager
    Join Date
    January 17th, 2007
    Location
    NY
    Posts
    191
    Quote Originally Posted by Mack
    I just played with it and it works well. Dropped in a feed with 300k items in it, did some fooling around with it, was ok.

    Not the fastest thing in the world to do. On my 3.4Ghz/2Gb ram machine it was still a little clunky, but it worked.

    The new office is ok. To me it looks more like a browser now than the old program. It's all very blue. I'm sure I can change the color but there's too damn many buttons everywhere.

    I'm about to get brave and try the new Outlook.
    I hope they arent following the look/functionality of IE7. I think its a truley awful, glitchy and bloated browser.

  9. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Top 100 Records?
    By Hectic GHC in forum Virtual Family and Off-Topic
    Replies: 21
    Last Post: July 19th, 2010, 01:58 PM
  2. FSBO 55,000 SF listed @ $10 Million
    By Merchant Consultant Team in forum Virtual Family and Off-Topic
    Replies: 2
    Last Post: June 16th, 2010, 02:58 AM
  3. Latest Blog Coming Along - Building 100 More
    By superCool in forum Blogging, Mobile and Social Media
    Replies: 19
    Last Post: December 14th, 2009, 10:28 PM
  4. Certegy Employee Steals 2.3 Million Financial Records
    By Thomas A. Rice in forum Midnight Cafe'
    Replies: 0
    Last Post: July 10th, 2007, 10:07 AM
  5. Replies: 4
    Last Post: March 9th, 2006, 01:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •