Null, "null", vbNull, vbNullString, vbEmpty

[[email protected]]

Hi,

if I am writing VBA code in MS EXCEL to insert 'nulls' into certain
cells,
so that when I import that into MS Access I can run queries with the
filter criteria such as

SELECT *
FROM blah
WHERE column Is Not Null

Then which Null do i use?

cell.Value = Null ?
cell.Value = "Null" ?
cell.Value = vbNull ?
cell.Value = vbNullString ?
cell.Value = vbEmpty ?


I'm all nulled crazy ...hehe.

[Harald Staff]

Excel cells can't afaik contain NULL. They will be either zero or an empty
string (which behaves like zero in Excel's calculations).

HTH. Best wishes Harald

<[email protected]> skrev i melding
news:[email protected]...
> Hi,
>
> if I am writing VBA code in MS EXCEL to insert 'nulls' into certain
> cells,
> so that when I import that into MS Access I can run queries with the
> filter criteria such as
>
> SELECT *
> FROM blah
> WHERE column Is Not Null
>
> Then which Null do i use?
>
> cell.Value = Null ?
> cell.Value = "Null" ?
> cell.Value = vbNull ?
> cell.Value = vbNullString ?
> cell.Value = vbEmpty ?
>
>
> I'm all nulled crazy ...hehe.
>

[Dave Peterson]

I don't speak the Access or the SQL, but in VBA these are almost equivalent:

cell.value = ""
cell.clearcontents

About the only time I've noticed a difference is when I'm dealing with merged
cells (yech!!!).



[email protected] wrote:
>
> Hi,
>
> if I am writing VBA code in MS EXCEL to insert 'nulls' into certain
> cells,
> so that when I import that into MS Access I can run queries with the
> filter criteria such as
>
> SELECT *
> FROM blah
> WHERE column Is Not Null
>
> Then which Null do i use?
>
> cell.Value = Null ?
> cell.Value = "Null" ?
> cell.Value = vbNull ?
> cell.Value = vbNullString ?
> cell.Value = vbEmpty ?
>
> I'm all nulled crazy ...hehe.

--

Dave Peterson