how to insert date value using asp in the Ms Access

hi all,
i m facing a problem while inserting a date field in the table.. my code for the same is follows
**************************************************

'''''''' Variable Declartions ofor DB connection
Dim moADOConn1 'Connection
Dim moRs1 'Recordset
Dim fetchRs2 'Recordset
Dim mstrConnString1 'Connection String
Dim ProdstrSQL1 'SQL

set moADOConn1=server.CreateObject("ADODB.Connection")
set moRs1=server.CreateObject("ADODB.Recordset")

moADOConn1.Open "DSN=cfs_site2" 'mstrConnString

HoliDt=Request.form("txtHoliDt")

ProdstrSQL1="insert into Holiday_Master values ('" & HoliDt & "')"

set moRs=moADOConn1.execute(ProdstrSQL1)


*********************************

error in the view source is



Microsoft OLE DB Provider for ODBC Drivers error '80040e07'



[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.



/cfs-test/AdminMenu.asp, line 111

********************************
line no. 111 is
set moRs=moADOConn1.execute(ProdstrSQL1)


please help me...
Thanks in advance
Deep

try this
(#" & HoliDt & "#)"

this link will explain what i have done and what the error means that you received.
http://www.adopenstatic.com/faq/80040e07.asp