coledatetime类型如何写入access日期字段

coledatetime类型怎么写入access日期字段?
高手指点咯,谢谢!


------解决方案--------------------
CString sql;
COleDateTime date;
= "update table_name set date_field = ' ";
sql+=date.Format( "%Y-%m-%d %H:%M ");
sql+= " ' ";