Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Location
    Riverwoods, IL, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linking to Excel (Access 2000)

    I am linking to an Excel file with 40,000+ lines. When I open the linked table in Access, only 16,300 lines show up. The same thing happens if I import the spreadsheet.

    Am I missing a setting or something?

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Linking to Excel (Access 2000)

    You are not missing anything. In checking the MSKB, I found that this is a known problem with Access97 (although no mention of such a problem with Access2000) and if the spreadsheet is stored in Excel97 format. The workaround is to open the spreadsheet in Excel prior to trying to import. Since you have a later version of Office, you might want to try opening the spreadsheet then use Save As to save it with the more recent Excel format.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    New Lounger
    Join Date
    Jul 2002
    Location
    Riverwoods, IL, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking to Excel (Access 2000)

    Thank you very much, Mark.

Posting Permissions

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