兄弟们来帮忙看个语法错误

[Roc_Lee]

insert into flow (Datetime,consume,type,category,scategory,remark) values (20090525,1,1,2,8,'娃哈哈的')
access
中显示insert into错误。实在不会了。求助
flow表
中字段除了remark都是int

[kkun_3yue3]

access啊,好久没用这个东东
提示啥错误
会不会是ACCESS文件共享的设置,还有文件只读的限制,

[kkun_3yue3]

insert into flow ([Datetime],consume,type,category,scategory,remark) values (20090525,1,1,2,8,'娃哈哈的') 

[Roc_Lee]

ok。搞定。

粗心粗心啊

[jwdream2008]

insert into flow ([Datetime],consume,type,category,scategory,remark) values (20090525,1,1,2,8,'娃哈哈的') 

insert into flow ([Datetime],consume,type,category,scategory,remark) values (20090525,1,1,2,8,'娃哈哈的')

[SQL77]

[Quote=引用楼主 Roc_Lee 的帖子:]
insert into flow (Datetime,consume,type,category,scategory,remark) values (20090525,1,1,2,8,'娃哈哈的')
access
中显示insert into错误。实在不会了。求助
flow表
中字段除了remark都是int
[/Quote]

insert into flow (Datetime,consume,type,category,scategory,remark) values ('2009.05.25',1,1,2,8,'娃哈哈的') 

[you_tube]

[Quote=引用楼主 Roc_Lee 的帖子:]
insert into flow (Datetime,consume,type,category,scategory,remark) values (20090525,1,1,2,8,'娃哈哈的')
access
中显示insert into错误。实在不会了。求助
flow表
中字段除了remark都是int
[/Quote]
insert into flow ([Datetime],consume,type,category,scategory,remark) values ('2009-05-25',1,1,2,8,'娃哈哈的')

[SQL77]

[Quote=引用 5 楼 SQL77 的回复:]
引用楼主 Roc_Lee 的帖子:
insert into flow (Datetime,consume,type,category,scategory,remark) values (20090525,1,1,2,8,'娃哈哈的')
access
中显示insert into错误。实在不会了。求助
flow表
中字段除了remark都是int



SQL codeinsert into flow (Datetime,consume,type,category,scategory,remark) values ('2009.05.25',1,1,2,8,'娃哈哈的')
[/Quote]
原来是字段名与标识符,弄错了向高手学习

[ai_li7758521]

学习