郁闷死了， 出现了个奇怪问题 SQL语句的

[jinesc]

一条INSERT INTO 语句 在ACCESS里怎么也执行不了 ， 老说我insert into 语法错误 在visdata里也一样
而同样的语句 在SQL SERVER里一次就成功

SQL 语句

insert into currency(rq,currency,id,usdrate,unitsrate) values('2004-08-06 09:49:42','Andorran Franc','ADF',0.1339,7.4659)



连接字符 ：
ACCESS
cn.Open "DBQ=" & App.Path & "\rate.mdb" & ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"

SQL SERVER
cn.Open "Driver={SQL Server};Server=192.168.100.100;Uid=sa;Pwd=*********;Database=sbcweb"



程序代码：

SQL = "insert into Curr(rq,Currency,code,usdrate,unitsrate) values("
SQL = SQL & "'" & Format(Now, "yyyy-MM-dd hh:nn:ss") & "',"
SQL = SQL & "'" & T1 & "',"
SQL = SQL & "'" & T2 & "',"
SQL = SQL & "" & T3 & ","
SQL = SQL & "" & T4 & ")"
cn.Execute SQL

[jinesc]

害得我折腾了一个小时了

[victorycyz]

insert into currency(rq,currency,id,usdrate,unitsrate) values(#2004-08-06 09:49:42#,'Andorran Franc','ADF',0.1339,7.4659)

[victorycyz]

SQL = "insert into Curr(rq,Currency,code,usdrate,unitsrate) values("
SQL = SQL & "#" & Format(Now, "yyyy-MM-dd hh:nn:ss") & "#,"
SQL = SQL & "'" & T1 & "',"
SQL = SQL & "'" & T2 & "',"
SQL = SQL & T3 & ","
SQL = SQL & T4 & ")"
cn.Execute SQL

[LGYAN]

Access里面日期前后要加"#",

而SQL server里面日期前后要加"'"

[jinesc]

和# 和‘没有关系的 我把日期型的去掉了 一样报错 ，

我朋友在他那倒可以用的 算了， 可能我机器的ACCESS 的驱动有问题



结贴