General discussion

  • Creator
  • #2075226

    Can’t Import Text file to Acc97


    by jackg ·

    I installed Office 97 to work on an Access project, however, I am unable to import the data which is in comma delimited text format.

    When I get to the “Import Data” wizard, text is not an option, only Access FoxPro, dBase, etc. are available filetypes.

    My first step was to run Add/Remove and make sure all file types were checked. That didn’t work.

    Next I tried reinstalling from the O97 Autorun/Setup menu. Nada.

    Next, I tried uninstalling Office then rebooted. When I reinstalled, I selected “Custom” and checked the “Select All” option. No luck there either.

    My final attempt, on my PC, was to again do the above then reboot several times to “clear” the registry of any Office keys, then reinstalled again. Same thing.

    In purefrustration, I tried installing Office on my wife’s computer and every feature works like a charm.

    Any ideas on what might be causing this anomaly? I thought maybe it was some isolated setting on my PC but I can’t think of what it might be.

    Jack Gold

All Comments

  • Author
    • #3790372

      Can’t Import Text file to Acc97

      by syscokid ·

      In reply to Can’t Import Text file to Acc97

      Sometimes you just want to wipe out Office 97 and all its settings. Uninstalling and re-installing Office 97 will replace many of the files, but not all of them – and the Registry doesn’t get scrubbed either. If you ever really, really want to delete Office 97 and everything that came with it:

      1. Run the uninstaller
      (from Start, Settings, Control Panel, Add/Remove Programs)

      2. Run the Office Clean program on the Office 97 CD.
      It’s at \valupack\offclean\offcln97.exe and it will clean out everything – including the Registry – thoroughly

      Then reinstall and see what happens.

      • #3788284

        Can’t Import Text file to Acc97

        by jackg ·

        In reply to Can’t Import Text file to Acc97

        It actually made things worse. Now Access will only recognize Access or ODBC file types and all my email, browser, and scanner defaults were blown away. I did, however, learn something new so you get an “E” for effort and 75 points.

    • #3790287

      Can’t Import Text file to Acc97

      by melodyj ·

      In reply to Can’t Import Text file to Acc97

      Try installing the Data Access Pack. I believe there is a Data Access directory on your OFF97 CD which contains a setup program.


      • #3788283

        Can’t Import Text file to Acc97

        by jackg ·

        In reply to Can’t Import Text file to Acc97

        I had tried that, however, the setup failed due to an SQL initialization problem. Apparently there is a setting on my machine somewhere that is squirrelly. I just don’t have a clue what it might be. I can compose and run SQL statements without any problem.

        Thanks anyway though

Viewing 1 reply thread