I am trying to inset into a SQL database table some information based on
cell entries. One of my fields takes a NULL value, when I look at the SQL
table it actually says NULL in there. So my question is how do I get the
Null into the table from my insert query?

Should the variable I'm copying the data from the cell to, be a Integer, or
String etc.

MySQL = "insert into carer
(carer_lookup_type,carer_code,carer_prompt,full_na me,carer_prompt_sp) values
(" & sLookup & ", " & _
iCarCode & ", '" & iPrompt & "', '" & sFname & "', '" & iSP & "')"

Thanks in advance