Well, thanks to you I was able to find something that I did not know before:
This works for me:

sqlexec(gnConnHandle,"insert into table_name (flddate) values (" +;
	iif(isnull(date_value) or empty(date_value), ;
               "NULL", ;
               "'"+dtoc(date_value)+"'")+")" )

>so you are passing dates a character. hmmm.
>
>But it works! except for blank dates. THEN IT CHOCKES.
>How does access want blank dates?
>
>Thanks
>
>Peter