Results 1 to 2 of 2
Thread: .xls, .txt, etc. (97)
2003-07-08, 21:01 #1
- 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>
2003-07-08, 21:30 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 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.