Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2002
    Location
    Lincoln, England
    Posts
    4

    Question Unanswered: Importing Excel into Access 97

    Hi folks

    I have a problem importing excel (and others) into Access 97.

    The problem is not that simple - I know that I can add/remove using setup choose data import, select all and all should be well. One problem there that is when you do this the options for excel, html and text imports are greyed out and state "already installed". Ho hum.

    To make matters worse because I work as a helpdesk for computer problems I have multiple databases and systems installed on both my main machines (home and office). I have installed Office95, Office 97 and Office 2000. clearly the problem lies with the import filters for these three. As a matter of interest the import works perfectly on Office 2000, I do not need to use the import facility on Office 95 but I do require it on Office 1997. I have installed the patch to enable Office 97 to work with Office 2000.

    Anybody any ideas.

    I have already removed all applications and reinstalled them in a different order but no avail.

    HELP

    jonellie

  2. #2
    Join Date
    Apr 2002
    Location
    Lincoln, England
    Posts
    4
    Just in case anyone is interested I now know the answer

    Jonellie

  3. #3
    Join Date
    Dec 2002
    Location
    Dothan, AL
    Posts
    4

    Importing Excel into Access 97

    I have the same problem. What's the answer?????

  4. #4
    Join Date
    Sep 2009
    Posts
    3
    I know it's been over 7 years but now (after installing Access 97 on a new computer) I have the same problem. Excel is no longer a choice in the list of file types. I've uninstalled/reinstalled everything I can think of. Can you tell me the answer? Thanks!

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    In the Office setup program, install the appropriate Data Sources.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    Sep 2009
    Posts
    3
    Thanks for a quick reply. If you mean what mine shows as Data Access, I've tried that many times. I highlight it, then click on Change Option..., then Database Drivers, Change Option.... The final selection screen shows Microsoft Excel Driver which is checked BUT the checkbox is gray indicating only part of the component will be installed. Somehow I can't help thinking that the part that is NOT installed is creating the problem. But I have been unable to eliminate the gray.

  7. #7
    Join Date
    Sep 2009
    Posts
    3
    I now also know the answer which I found in a Microsoft Product and Technology Communities forum. Here it is:

    Re-register the following files:
    msexcl40.dll (Excel)
    msxbse40.dll (dBase)
    mspdox40.dll (Paradox)
    mstext40.dll (Text, CSV, tab-delimited)

    IMPORTANT: In Access 97, the filenames contain 35 instead of 40.

    Also, try re-registering this file:
    Accwiz.dll

    To re-register a DLL file,

    1) Locate it (usually all these are in the Windows\System32 or WINNT\System32 folder.

    2) Locate the file regsvr32.exe.

    3) Drag the DLL file's icon onto the regsvr32.exe icon.

    OR:

    Run from Start | Run window:

    Example:

    Regsvr32 "C:\windows\system32\msexcl40.DLL"

    etc.

Posting Permissions

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