Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Mar 2002
    Location
    Western NY, USA
    Posts
    157
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Max file size? (2003 SP2)

    We are trying to import a text file. We have an addin which will automatically splits the file among sheets. We have tried importing on a couple of different engineering workstations with 8gig of memory. In both cases the number of lines from the file imported is 1,047,360, with an Excel file size of 287081 mg.

    Have we reached Excel's upper limit?

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Max file size? (2003 SP2)

    Not necessarily - more likely the limit is in the add-in, either in imported line count or memory management. Can you provide more detail? Is this a commercial add-in, or internally built? Would it make more sense to import this data into Access?
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Max file size? (2003 SP2)

    What exactly do you mean by "an Excel file size of 287081 mg"? 287GB? 287MB? something else? And what problem are you running into exactly? (I wouldn't like to try and work with a 280MB file in Excel personally)
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    2 Star Lounger
    Join Date
    Mar 2002
    Location
    Western NY, USA
    Posts
    157
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Max file size? (2003 SP2)

    The file is 287MB.

    I agree with you and tried to steer the user to another application. However, he is an engineer and knows how to use Excel. If we were to put the data into Oracle and then extract the data he needs to work with at the moment, he will feel like he lost control. An engineer cannot have that!

    Thanks.

    Mostly I am interested in whether we have hit the ceiling. I believe there are other products we can use, like Oracle and Minitab, and I am pushing the user that direction.

    Thanks.

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Max file size? (2003 SP2)

    The memory limit for Excel was increased from 128MB in 2002 versions to 1GB in 2003 versions. This is per instance of Excel, so all workbooks in a given instance contribute towards the aggregate usage. I don't know what the engineer wants to do with this data, but some sort of db back end sounds much more sensible, whether Oracle, SQL Server, Access or whatever. That way he should still have all the data, but can run pivot tables/queries directly off the data rather than having to dump it all into Excel.
    Regards,
    Rory

    Microsoft MVP - Excel

  6. #6
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Long Beach, California, USA
    Posts
    233
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Max file size? (2003 SP2)

    Here is a link to a site that discusses Excel and memory.

  7. #7
    2 Star Lounger
    Join Date
    Mar 2002
    Location
    Western NY, USA
    Posts
    157
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Max file size? (2003 SP2)

    Thanks, that was helpful.

    We have persuaded the Engineer that he needs to trim his data with another application and that he can use Excel with a smaller data set.

Posting Permissions

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