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

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

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

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