Return
-
Title
In Excel connection, how to query that can convert the null cells to zero? -
Description
User is connected to Excel. Data grid returns cells that are null. User wants to write a query that can convert the null cells to zero so math can be done between columns. This is available in Oracle and SQL Server. User does not want to enable an option that converts the data grid nulls into zeros.
-
Resolution
Use the code below within the query; where column_name is column with the {null} data cells.
SELECT Iif(AutoRange_Sheet1.column_name IS NULL, 0, AutoRange_Sheet1. column_name)
FROM AutoRange_Sheet1 AutoRange_Sheet1