Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post

    Analyze > 16K records (in Excel) (2000, SR-1)

    I have Access 2000 and Excel 2000. I have a table in an Access database with about 25K records. When I select Tools | Office LInks | Analyze It with MS Excel, it creates an Excel workbook, but truncates after 16K records. It seems to be creating an old version Excel file (5.0?). It's possible that my PC was upgraded from Office 97 to Office 2000, so I'm wondering if that's part of the reason. I realize I could completely uninstall Office 2000 and then reinstall it, but does anybody know if there's an easier way? TIA.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Analyze > 16K records (in Excel) (2000, SR-1)

    It seems to me that's a known issue (feature?) with Access. In other words, I don't think uninstalling and reinstalling will fix it. You could try the Export command in Access, or you could use the TransferSpreadsheet command from VBA. This MS Knowledge Base article gives details on what's going on.
    Wendell

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Pennsylvania, USA
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Analyze > 16K records (in Excel) (2000, SR-1)

    I checked the Microsoft Knowledge Base and found that, "for backwards compatibility", it uses Excel 5.0 when you do "Analyze with Excel". Also, it implies that there is no fix for this, but gives three "workarounds". You can refer to Microsoft Knowledge Base article number Q201589 for more information.

    Edited by Charlotte to activate link

Posting Permissions

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