I received the following error message when trying to create a new database query in Excel 2003:
Can’t access table C:Documents and Settings…My DocumentsTester.mdb.qryTest.
I found a few knowledge base articles, but nothing relevant to my situation. I almost never use the wizard to create external data queries, but I thought I’d give it a shot. Using the wizard, I get this error:
Undefined function ‘Nz’ in expression.
Well that’s a little more helpful. In fact, I do use the Nz function in the query I’m trying to bring over. I changed from:
and it all works fine. Oh, except for this persistent little problem.
The moral is that MSQuery doesn’t like the Nz function.