Inseting DateTime into MSAccess

[tmarunkumarit]

I want to insert datetime values into msaccess using asp.net by vb.. Am getting error that Syntax Error in INSERT INTO statement...

My query is
strSQL="insert into group0 (name,addressline1,addressline2,landmark,city,stat e,pincode,telephone1,telephone2,altcontactno,busin esscategory,product,category,date) values('" & txtname.text & "','" & txtadds1.text & "','" & txtadds2.text & "','" & txtland.text & "', '" & txtcity.text & "', '" & txtstate.text & "' , '" & txtpin.text & "','" & txttel1.text & "','" & txttel2.text & "','" & txtmob.text & "','" & txtbus.text & "','" & txtpro.text & "','" & txtcat.text & "','" & now & "')"

please help me... send to my email id

[RobinS]

Date/Time fields in MS Access are delimited by the octothorpe (#), not the
single quote.

Robin S.
--------------------------------------
<tm***********@yahoo.com.sgwrote in message
news:un**************@TK2MSFTNGP06.phx.gbl...

>I want to insert datetime values into msaccess using asp.net by vb.. Am
getting error that Syntax Error in INSERT INTO statement...

My query is
strSQL="insert into group0
(name,addressline1,addressline2,landmark,city,stat e,pincode,telephone1,telephone2,altcontactno,busin esscategory,product,category,date)
values('" & txtname.text & "','" & txtadds1.text & "','" & txtadds2.text
& "','" & txtland.text & "', '" & txtcity.text & "', '" & txtstate.text &
"' , '" & txtpin.text & "','" & txttel1.text & "','" & txttel2.text &
"','" & txtmob.text & "','" & txtbus.text & "','" & txtpro.text & "','" &
txtcat.text & "','" & now & "')"

please help me... send to my email id

[=?Utf-8?B?TWljaGVsIFBvc3NldGggW01DUF0=?=]

Well you can actually insert this as a string and as far as i know to every
database ( inclusive Access ) that acceptst the ISO 8601 standard

ISO 8601 implements a universal date format ( example : 2004-05-23T14:25:10)

YYYYMMDD

INSERT INTO Testtabel
(Test)
Values ('2007-01-01')
however as above wil function without problems on any system ( regrdless of
the date time settings )
the recomended way is to use Parameterized query`s in combination with a
..Net date type

HTH

Michel Posseth
"RobinS" wrote:

Date/Time fields in MS Access are delimited by the octothorpe (#), not the
single quote.

Robin S.
--------------------------------------
<tm***********@yahoo.com.sgwrote in message
news:un**************@TK2MSFTNGP06.phx.gbl...

I want to insert datetime values into msaccess using asp.net by vb.. Am
getting error that Syntax Error in INSERT INTO statement...

My query is
strSQL="insert into group0
(name,addressline1,addressline2,landmark,city,stat e,pincode,telephone1,telephone2,altcontactno,busin esscategory,product,category,date)
values('" & txtname.text & "','" & txtadds1.text & "','" & txtadds2.text
& "','" & txtland.text & "', '" & txtcity.text & "', '" & txtstate.text &
"' , '" & txtpin.text & "','" & txttel1.text & "','" & txttel2.text &
"','" & txtmob.text & "','" & txtbus.text & "','" & txtpro.text & "','" &
txtcat.text & "','" & now & "')"

please help me... send to my email id