Inseting DateTime into MSAccess

  • Thread starter Thread starter tmarunkumarit
  • Start date Start date
T

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,state,pincode,telephone1,telephone2,altcontactno,businesscategory,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
 
Date/Time fields in MS Access are delimited by the octothorpe (#), not the
single quote.

Robin S.
 
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
 
Back
Top