The ADP file is not in the correct format for a Microsoft Access project

G

Guest

That's the error message I get when I try to link to or import an Excel spreadsheet. This is in a database that was working fine one day, and having this problem the next. The only thing I can find in KnowledgeBase, or MS in general has to do with Bookmarks, which I'm not using at all. Any help on this would be greatly appreciated!
 
Joined
Apr 26, 2006
Messages
1
Reaction score
0
I've just had the same problem. I was tring to import an Excel spreadsheet into Access - has worked perfectly on the previous occasions that I have had to use this particular database. I was opening Access and locating the spreadsheet to import using *.* within the relevant directory, got same error message as you. When I selected .xls in the file type, rather than using *.* in filename, the file imported correctly. Access would appear to not recognise .xls extensions as Excel unless you specifically tell it in the "Files of type" box.


Good Luck!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top