Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.70K
1 Posted Topic
Aditya, I'd guess it's the field called Type giving you problems, as Type is possibly a reserved word in SQLServer. Putting it in square brackets should avoid this problem. So, try: sql2 = " INSERT into Sheet1(DWNLDQPID,PO,Material,Date,SO,LI,QTY,Jurisdiction,Program,[Type],UNCFD QTY,Label SIQPID,Sign off)VALUE('1',PORECNUM.TEXT,'3','4','5','6','7','8','9','10','11','12','13')" cymapAndy.
The End.