I’m getting an error in MSQuery. I’ve had nothing but trouble with MSQuery since I changed employment. The current error I’m getting is:
The Microsoft Office Access database engine cannot find the input table or query ‘mdb.tblDocuments’. Make sure it exists and that its name is spelled correctly.
Aside: I just had to type that error message because error text in a message box isn’t copy-able.
The SQL statement MSQuery generates is:
It seemed to me that it chose odd location for the quote marks, particularly since there are no spaces in the path. I tried deleting the quote marks, I tried putting the quote mark after mdb, and I tried putting the quote mark after tblDocuments. I also tried messing with that period between mdb and tblDocuments. Deleting them produced the same error. Moving them created two errors in succession, namely:
SQL Query can’t be represented graphically. Continue anyway?
Could not add the table “C:AIMCDConfig.mdbtblDocuments”.
What finally worked is:
I still can’t get rid of the “can’t be represented graphically” message, but it works. Once I get the query in Excel, I manually change the CommandText property to:
and it works like a peach.
As for the error message, there’s a utility named SnagIt that can capture most text on screen. And if it’s too expensive, you could always use Print Screen, paste into the Microsoft Document Imaging applet and run the image through OCR.
Thanks fzz. I own SnagIt and I love that program. I put that utility (screen capture to OCR to clipboard) on my list of stuff to write.
As you know I’m no Wordsworth, but is it spelled or spelt?
Strange that MSQ should be causing problems for you on this PC – any ideas why? – Anyone?
Ross, according to the world wide web, either is correct, with “ed” being more common in the US. Although I don’t think you can say “I was tired, so he spelt me for 15 minutes.” And there’s no such thing as spelled bread.
I have found with Access in the past that you have to use the “” rather than the ” with Excel as you are referring to a database extension .mdb the “” would be required.
Doug, well there you go!
As for getting the text from a message box, have you tried the Windows-standard way of just pressing Ctrl-C? It works most of the time.
I am having exact same problem.
I am not sure if it has to do with the database being located on the network.
If I copy the database to “mt Documents” folder and re-link the pivot table to it it works flawlessly, but if i link to the database ( the same one) located anywhere except my documents it will give me the same error message as above.
any help will be appreciated.
K
Anyone find a cause for this? Cannot find any other documentation other than this page.
i fixed my problem by “detect and repair” function on excel help menu.
good luck
I was getting a similar message in Excel while using Import External Data > New Database Query and also solved it using DETECT AND REPAIR on the Help Menu.
Thanks Kolya!
Just another vote of thanks to Kolya. I had this problem yesterday and “Detect and Repair” has taken care of it. Thanks!
You guys rock, that totally fixed it for me as well!! “Detect and Repair” under Excel – Help!! Thanks!!!!
Had right now the same problem. “Detect and repair” does the job. Wasted quite some time looking for the answer on microsoft.com …
Kolya solution rocks. I tried and it worked. Thank you so much. Made my day!!!!