VB.NET - VB.NET MDB DateTime field

Asked By Jeff J on 01-Apr-11 09:33 PM

How do you insert into a datetime field in an Access MDB.

I tried DateTime.Now, but that is not an acceptable format.

Anoop S replied to Jeff J on 02-Apr-11 12:14 AM
Try like this way
strSQL="INSERT INTO tablename (datefild) values('" Now "')"
Jeff J replied to Anoop S on 02-Apr-11 04:55 PM
this would have worked in VB6.

but not .net. tried it.