Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to test for imported Access table null cell?
Greetings!
Am reading data from Excel into Access to do some manipulations, then bringing it back to Excel. A new field in the Access return data sometimes has a null value. I see I can use the Access NZ function in the query to force it to a "" value rather than null. However, as is, I have a cell value in the return data that shows up in an Excel pivot table (snapped on the data table) field value selection list as a colored box, different than a text value or a blank (i.e. ""). The cell has no value that I can detect, but trying to use it in any operation (calculation or feed to function) results in an error. Question, then: is there a function or other method, preferably available on the worksheet but as a fallback as an attribute accessible via VBA, that I can use to detect a null cell in Excel originating from an imported Access table? Thanks, George |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to test for imported Access table null cell?
G Lykos,
Could you please =CODE(<cell) and tell me what it returns? Might be easier to figure out if we knew what code was inside the cell itself. -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''Yes'' below. "G Lykos" wrote: Greetings! Am reading data from Excel into Access to do some manipulations, then bringing it back to Excel. A new field in the Access return data sometimes has a null value. I see I can use the Access NZ function in the query to force it to a "" value rather than null. However, as is, I have a cell value in the return data that shows up in an Excel pivot table (snapped on the data table) field value selection list as a colored box, different than a text value or a blank (i.e. ""). The cell has no value that I can detect, but trying to use it in any operation (calculation or feed to function) results in an error. Question, then: is there a function or other method, preferably available on the worksheet but as a fallback as an attribute accessible via VBA, that I can use to detect a null cell in Excel originating from an imported Access table? Thanks, George |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to test for imported Access table null cell?
=CODE(<cell) returns #VALUE!. =<cell*1 returns likewise.
"Thomas [PBD]" wrote in message ... G Lykos, Could you please =CODE(<cell) and tell me what it returns? Might be easier to figure out if we knew what code was inside the cell itself. -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''Yes'' below. "G Lykos" wrote: Greetings! Am reading data from Excel into Access to do some manipulations, then bringing it back to Excel. A new field in the Access return data sometimes has a null value. I see I can use the Access NZ function in the query to force it to a "" value rather than null. However, as is, I have a cell value in the return data that shows up in an Excel pivot table (snapped on the data table) field value selection list as a colored box, different than a text value or a blank (i.e. ""). The cell has no value that I can detect, but trying to use it in any operation (calculation or feed to function) results in an error. Question, then: is there a function or other method, preferably available on the worksheet but as a fallback as an attribute accessible via VBA, that I can use to detect a null cell in Excel originating from an imported Access table? Thanks, George |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to test for imported Access table null cell?
Well the #Value is a semi-good answer. That means that the cell value is in
fact empty (completely empty). When you pull your pivottable, does it return a (blank) category on the dropdowns? Secondly, what are you attempting to do? Eliminate the (blank) from the PivotTable? -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''Yes'' below. "G Lykos" wrote: =CODE(<cell) returns #VALUE!. =<cell*1 returns likewise. "Thomas [PBD]" wrote in message ... G Lykos, Could you please =CODE(<cell) and tell me what it returns? Might be easier to figure out if we knew what code was inside the cell itself. -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''Yes'' below. "G Lykos" wrote: Greetings! Am reading data from Excel into Access to do some manipulations, then bringing it back to Excel. A new field in the Access return data sometimes has a null value. I see I can use the Access NZ function in the query to force it to a "" value rather than null. However, as is, I have a cell value in the return data that shows up in an Excel pivot table (snapped on the data table) field value selection list as a colored box, different than a text value or a blank (i.e. ""). The cell has no value that I can detect, but trying to use it in any operation (calculation or feed to function) results in an error. Question, then: is there a function or other method, preferably available on the worksheet but as a fallback as an attribute accessible via VBA, that I can use to detect a null cell in Excel originating from an imported Access table? Thanks, George |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Failed to save table attributes of (null) into (null). | Excel Discussion (Misc queries) | |||
Replace NA with Null - Access 2003 | Excel Discussion (Misc queries) | |||
Test for null - insert a row if isnull | Excel Discussion (Misc queries) | |||
cell value based on null/not null in another cell | Excel Worksheet Functions | |||
My formulas can't 'see' numbers imported from Access in Excel, even when the format is the same. | Excel Discussion (Misc queries) |