[AccessD] ADO Problem

Dear List:

A colleague (who thinks I know ADO) writes in to ask why the following:

   Conn.Execute "INSERT INTO tWeeklyUpdateSent ( DateSent ) " & _
                 "SELECT " & dtToday & ""

Inserts a record into tWeeklyUpdateSent so the conection is OK.  But but the
date is 1/1/1900 instead of today’s date.

I had him check the contents of dtToday and it does indeed have 11/28/2006
in it.

Does anyone see what he's doing wrong here?


MTIA

Rocky