[AccessD] ADO Problem

Gustav Brock Gustav at cactus.dk
Wed Nov 29 02:28:34 CST 2006


Hi James and Rocky

Well, this will only work in a US environment. 
As A.D states, anyone else will have to format the date value as a US formatted date/time expression or - most SQL engines accept that nowadays - an ISO formatted date/time expression with or without slashes: yyyy-mm-dd hh:nn:ss

/gustav

>>> James at fcidms.com 28-11-2006 20:55:01 >>>
Rocky:
You probably want something like:

Conn.Execute "INSERT INTO tWeeklyUpdateSent ( DateSent ) Values (#" &
dtToday & "#)" 

This will work with an ADODB connection to Access. If you are linking to SQL
Server, you should replace the # with ' (Single Quote).

Hope this helps.

James Barash




More information about the AccessD mailing list