Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Import Excel (Office 97)

    I cannot get office 97 to install the data access for Excel so that I can import spreadsheets into tables.

    I read what it say's just above the drop down box re-install and check the data access box and select all
    I have tried this several times but it still does not appear in the dropdown box for selection.
    I feel there must be a way to get it in there!
    Thanks in advance
    <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>
    If you are a fool at forty, you will always be a fool

  2. #2
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Import Excel (Office 97)

    You are probably missing some of the registry keys found under HKEY_LOCAL_MACHINESoftwareMicrosoftJet3.5ISAM Formats. You may want to take a look at the following MS Knowledge Base article which includes some possible fixes:

    <A target="_blank" HREF="http://support.microsoft.com/default.aspx?scid=kb;en-us;Q160954">Removing/Adding Wizards Fails to Create ISAM Registry Key (Q160954)
    </A>

    HTH

  3. #3
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Import Excel (Office 97)

    PS: There's another MSKB article which may apply in your case:

    ACC97: Certain ISAM Drivers Not Appearing in Files Of Type Box (Q171955)

  4. #4
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Import Excel (Office 97)

    Hi MarkD

    Thanks for the advice I downloaded Q160954 and followed the instructions exactly but to no avail. so I downloaded the Office 97 service pack and would
    you believe it, it loaded everything except Excel which is all Wanted.

    Yours frustated
    If you are a fool at forty, you will always be a fool

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Import Excel (Office 97)

    Hi MardD

    It's me again the registry tip was the best. I just went in and copied the settings from another registery.

    Thanks Again
    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    If you are a fool at forty, you will always be a fool

  6. #6
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Import Excel (Office 97)

    When I was still using Office 97 & had same problem that's how I had to fix it too - export ISAM registry key from a "good" machine and import into the "broke" machine.

Posting Permissions

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