Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Feb 2002
    Albuquerque, New Mexico, USA
    Thanked 0 Times in 0 Posts

    .xls, .txt, etc. (97)

    I know I've seen this before but . . .
    I'm looking for the way to import Excel, text, comma delimited, etc. files into Access. I reinstalled Access with all the bells and whistles and I still don't have this feature. I can only get to Access files. There is a registry setting that sometimes gets fouled up. Does anyone know what it is?

    I promise I will save it this time!

    <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23> <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35> <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: .xls, .txt, etc. (97)

    Do you have the menu items File | Get External Data | Import... and File | Get External Data | Link Tables... ?

    If so, and if you select on of them, does the Open/Link dialog contain a File Types combo box at the bottom of the dialog?

    If so, which file types can you find in the dropdown list (you may have to scroll to see them all)?

    If Excel is missing from the dropdown list, take a look at ACC: Troubleshoot "Couldn't Find Installable ISAM" Error. Although this article speaks about exporting to Excel, it applies to importing too.

Posting Permissions

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