(Leo)Importing Data Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, Experts
I was trying to import an MS Access Query to my Excel sheet,(through
Importing Data Tool inside Excel) but the process failed by saying that it
doesnt know the NZ function (a function that I used in my query to remove
Null value).
How can it be fixed? and what does this have to do with my excel sheet?
 
I tested your issue and I don't think there be a solution to the error.
Go for the Work-Around.
Use a different method of replacing the Null values ...
NewElement: IIf([Value] Is Null,"New Value",[Value])

or export directly from Access instead of importing from Excel.
 
Back
Top