Hello All,
I have a database based on Microsoft Access 2013.
It has a query which uses "NZ" funtion inorder to convert all blank cells into cells having "0".
Now I want to import data into excel from access. But when doing so I am getting an error message saying "Undefined funtion NZ in expression.

In other words# Microsoft excel is not recognizing the Nz function. *

So what is the solution?
Is there anyother way to import tables from Access.

It will be helpful if I get a reply asap.

Thank you all

You could replace Nz(expression,replacement) with IIf(IsNull(expression),replacement,expression) to avoid the use of Nz.

Hello Hans,
Thanks for the quick response.
I have used so many Nz function that I cant change it into IIF.

So I planned to run the query and make table, thereby exporting the table.
So that no formulas are being exported to excel.
Any comment on my idea?