Hello,
I have an array from which I load values into a table.
My table creation is done using ADO.
Some of the fields in the Array can have null values and I want to
load the corresponding table field with the same values as in the
array - that is null or non-null values.
I have defined text fields in ADO in table creation as follows:
With tbl
..Name = "tbl_Name"
Set .ParentCatalog = cat
..Columns.Append "Case_Field", adWChar
End With
When the array contains null values I get a message saying "You tried
to assign a Null Value for a variable that is not Variant Data Type"
What should I change in the above code in order that this message does
not appear?
Thanks in advance.
Uttam