Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Null To Zero - ODBC Error - Undefined function 'Nz' in Expression
I'm trying to Import Data into Excel from an Access Query that uses the Nz
function. I'm getting an error before the data even appears in Excel. Error is "[Microsoft][ODBC Microsoft Access Driver] Undefined function 'Nz' in expression." I've read the email string submittted by DEI on 10/17/05 but think this is a different problem. Any ideas how I can overcome the error? Thanks, Nancy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Null To Zero - ODBC Error - Undefined function 'Nz' in Expression
Nancy,
I don't know if this will fix your issue, but you may try going into the VBE and go to <Tools then <References then check "Microsoft Access X.X Object Library" where X.X is the highest version number available. HTH "Nancy" wrote: I'm trying to Import Data into Excel from an Access Query that uses the Nz function. I'm getting an error before the data even appears in Excel. Error is "[Microsoft][ODBC Microsoft Access Driver] Undefined function 'Nz' in expression." I've read the email string submittted by DEI on 10/17/05 but think this is a different problem. Any ideas how I can overcome the error? Thanks, Nancy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Null To Zero - ODBC Error - Undefined function 'Nz' in Express
I tried that but nothing changed. By the way, I'm using the built-in Import
Data function in Excel. Thanks anyway. "quartz" wrote: Nancy, I don't know if this will fix your issue, but you may try going into the VBE and go to <Tools then <References then check "Microsoft Access X.X Object Library" where X.X is the highest version number available. HTH "Nancy" wrote: I'm trying to Import Data into Excel from an Access Query that uses the Nz function. I'm getting an error before the data even appears in Excel. Error is "[Microsoft][ODBC Microsoft Access Driver] Undefined function 'Nz' in expression." I've read the email string submittted by DEI on 10/17/05 but think this is a different problem. Any ideas how I can overcome the error? Thanks, Nancy |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Null To Zero - ODBC Error - Undefined function 'Nz' in Express
In that case, I'm not sure what is going on except that maybe Excel via the
ODBC driver doesn't recognize NZ. The only other thing I can think of would be to switch from NZ to IIF instead? HTH "Nancy" wrote: I tried that but nothing changed. By the way, I'm using the built-in Import Data function in Excel. Thanks anyway. "quartz" wrote: Nancy, I don't know if this will fix your issue, but you may try going into the VBE and go to <Tools then <References then check "Microsoft Access X.X Object Library" where X.X is the highest version number available. HTH "Nancy" wrote: I'm trying to Import Data into Excel from an Access Query that uses the Nz function. I'm getting an error before the data even appears in Excel. Error is "[Microsoft][ODBC Microsoft Access Driver] Undefined function 'Nz' in expression." I've read the email string submittted by DEI on 10/17/05 but think this is a different problem. Any ideas how I can overcome the error? Thanks, Nancy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error: Undefined or non-rectangular name | Excel Worksheet Functions | |||
Excel error: Undefined Function 'InStrRev' in Expression | Excel Worksheet Functions | |||
Undefined function error | Excel Discussion (Misc queries) | |||
undefined function error when creating xls pivot from mdb qry | Excel Worksheet Functions | |||
'Undefined Function' Error in Microsoft Query | Excel Programming |