dim ssql as string
dim i as long
ssql="select * from 阁下的数据表名称"
rs.Open ssql, CurrentProject.Connection, adOpenKeyset, adLockOptimistic
for i=1 to rs.recordcount
rs!日期型日期字段的名称.value=cdate(rs!文本型日期字段的名称.value)
rs.update
rs.movenext
next
rs.close
set rs=nothing