I have a simple excel spreadsheet in a folder. When I go to import it the dialogue box shows other spreadsheets in that folder but not this one. How do I change the sheet so Access sees it?
Novice
Windows XP 
Access 2003
I have a simple excel spreadsheet in a folder. When I go to import it the dialogue box shows other spreadsheets in that folder but not this one. How do I change the sheet so Access sees it?
Sometimes Helpful
Windows 7 64bit Access 2010 32bit
Sounds like you may be using the Wizard to do the import and the file type you are looking for is not part of the filtered file types. You might try clicking the file type option in the lower right of the dialog to include all files or something. I am guessing the Excel file you wish to import is of an older version or is macro enabled or something.
VIP
Windows Vista Access 2010 32bit
I too have seen this. Ticks me off.
Tho the file IS there. If I paste the path /file name it works, but it cant always display it for some reason.
Try F5 to refresh.
Macros to make Sheet 1 Look like Sheet 2 in EXCEL
Posting Permissions
Reply With Quote