Issue with OLDB Access driver

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

September 7th, 2015 9:10am

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

Free Windows Admin Tool Kit Click here and download it now
September 7th, 2015 9:22am

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?

September 7th, 2015 9:50am

That's another good way to do it.
Free Windows Admin Tool Kit Click here and download it now
September 7th, 2015 10:17am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics