Access XP Import (from Excel XP) Errors

[Dennis]

I am using Excel XP to import a single sheet to Access
XP. Every single time I get this error:

"The wizard is unable to access information in the
file '<pathname>'. Please check that the file exists and
that the file is in the correct format."

The cause is not an ISAM issue as I checked the files and
registry entries for same as suggested in Knowledge Base
#209805; 283881; 90111; and 142473.

My work-a-round is to export from Excel to a text file,
then to import that text file into Access. This is the
long way around the barn.

Also, where can I obtain a comprehensive list of Excel &
Access Errors and Advisories and solutions to same?

Any help would be wonderful.

Happy Holidays!

Dennis

 

[Ken Snell]

I have seen this error when the length of the path and filename is *long*
(over 64 characters?). Try moving the EXCEL file to a higher level folder
and see if it works then.

 

[Guest]

Thanks for your time!

My filename+path is under 64 characters. I have a
feeling that XL saves and retains quite a bit of
historical garbage that even MS Access has issues with.

 

[Ken Snell]

Is the file password protected?

What is the actual path / file name that you're using?