Date and oledb
 

I need help,i have a problem,i cant seem to insert from my vb interface to my access database...for example the access field is a fate type......how am i supposed to do it?,like if i enter my date like 24/2/08,it ll go in database,i tried my oledb.varchar,oledb.dbdate also does not work....can some1 help me out with this...everytime i use it i get error in insert into statement

Re: Date and oledb
 

What error message do you get?

Does this work in your code:

Dim oConn As OleDbConnection

Dim oCmd As OleDbCommand

Dim strSQL As String

Dim myDate As Date



myDate = CDate("4.10.2008") ' Use your locale date format, like "10/4/2008"

strSQL = "INSERT INTO <mytable> (<my date field>) VALUES ('" & myDate & "')"

oConn = New OleDbConnection("<your connectionstring")

oConn.Open()

oCmd = New OleDbCommand(strSQL, oConn)

oCmd.ExecuteNonQuery()