当前位置:编程学习 > C#/ASP.NET >>

Syntax error in INSERT INTO statement.

INSERT INTO [Combine$] (Grou,Product,PN,Describ,Pri,Week,Q1,Q2,Q3,Q4,W1,W2,W3,W4,W5,W6,W7,W8,W9,W10,W11,W12,W13,W14,W15,W16,W17,W18,W19,W20,W21,W22,W23,W24,W25,W26,W27,W28,W29,W30,W31,W32,W33,W34,W35,W36,W37,W38,W39,W40,W41,W42,W43,W44,W45,W46,W47,W48,W49,W50,W51,W52,W53,W54,[Jan Qty],[Feb Qty],[Mar Qty],[Q1 Qty],[Apr Qty],[May Qty],[Jun Qty],[Q2 Qty],[Jul Qty],[Aug Qty],[Sep Qty],[Q3 Qty],[Oct Qty],[Nov Qty],[Dec Qty],[Q4 Qty]) VALUES('DCCS','','7542238-01','Fin.Ampl. 350W 1930-1995 43dB','Tr.Schd.  fix','W5','217','410','370','185',,,,'5','90','30','35','30','65','25','20','40','25','10','25','20','95','0','0','45','40','35','50','0','65','5','0','55','35','10','0','50','35','30','0','50','0','5','30','50','0','25','25','217','410','370','185','0','32','185','175','150','85','155','0','32','185', '217','175','150','85','410','155','100','115','370', '85','100','','185')
这段语句为什么会出现这个错误呢?我检查了保留字,求指点。 --------------------编程问答-------------------- 另外请问一下在插入到excel后数字都是text格式的,怎么在程序里设定成数字保存?
补充:.NET技术 ,  C#
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,