Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts

    data will not fit (excel 2002)

    I am importing data into excel from as400. There are 24,000 records and once 16,351 records are imported, it stops with the error "the data will not fit in the worksheet'. This same import works perfect in excel 2000.
    sp3 is installed and I also checked off "ignore other applications".
    Does anyone know how to fit this?
    Thanks..Susan

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: data will not fit (excel 2002)

    Hi Susan

    I have this problem all the time[gggrrr].

    Is there the option to extract your data in the form of a CSV file? If so you can then re-import to Excel. I often do this if I am in a rush to get a job done and is a work around. I am sure that there may be a permanent fix but it may help you in the interim period. Good luck
    Jerry

Posting Permissions

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