View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jason.teen@gmail.com is offline
external usenet poster
 
Posts: 3
Default Null, "null", vbNull, vbNullString, vbEmpty

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. :)