Hi,
Im wanting to insert a date value (quote_date) into a a table called "quotes". I have formatted into my database for my VB application. Can someone give me some pointers. Here is my code so far

Public Sub InsertQuote(strQuoteDate As Date)
Dim strSql As String

strSql = "insert into quotes (quote_date) values(" & strQuoteDate & ")"

oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=c:\irs\irs1.mdb;" & _
"Uid=admin;" & _
"Pwd="


End Sub

Basically, How do I execute it and format it for my access database to accept?

Andy