importing to access-error message

[markmerid]

I am trying to import an excel file into Access- which I have successfully done before, but now it displays an error message saying "The wizard is unable to access info in the file. Please check that the file exists and that it is in the corect format". Does anybody know why it is saying this? and more importantly how to overcome it? Thanks

 

[Joe4]

How are you trying to import the file? Manually, or with code?

Does the file use an XLS extension?

 

[markmerid]

Microsoft access-import to excel- error msg

I am importing it manuallyand the file does have a .xls extension so I am a bit confused to why it is doing this??

 

[Joe4]

Can you open this file in Excel? Is it password protected, contain macros, or is read-only or anything of that nature?