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')
这段语句为什么会出现这个错误呢？我检查了保留字，求指点。

1 个解决方案

#1

另外请问一下在插入到excel后数字都是text格式的，怎么在程序里设定成数字保存？