View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nancy Nancy is offline
external usenet poster
 
Posts: 41
Default 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