请看一下我写的SQL语句,有什么问题吗?

[gx_sunny]

我在VB里写的SQL语句,我觉得没有毛病,但是它一直报错,说语法错误,请各位高手指教!

insert into HUMANDATA(NAME,NUMBER,SEXID,AGE,BIRTHDAY,RUNDEGREEID,SPORTITEMID,PLACEID,IDCARD) " _
& " values " _
& "('" & Trim(Txt(0).Text) & "'," _
& " '" & Trim(Txt(1).Text) & "'," _
& " " & 0 & "," _
& " " & DateDiff("yyyy", DTPker.Value, Now()) & "," _
& " # " & DTPker.Value & " #," _
& " " & Rid & " ," _
& " " & Sid & " ," _
& " " & Pid & " ," _
& " '" & Trim(Txt(2).Text) & "')"

[008]

values与(' 之间不应该有空格。还有我不明白你为什么不加"'"，而是& " " & 。或者你是不是有非空子段没有进行赋值。

[huitor]

可能是保留字冲突问题。建议：
将字段名name换成别的名字，如xname，再试。

[Calf]

表名和字段左括弧之间应该有空格吧？