Ok, I shouldn't do all the work for you, but I got too much time on my hands today, so...
Your sSQL string will look like:
Code:
" INSERT INTO empd (PAN,PEN,ENAME,DESIG,ADDR,ONAME,PLACE,DOB,DOJ,BP,G PF,SLI,GIS,LIC,FBS,SOP)
VALUES ( 12345 , ABCDE1254W , 'CHARLIE' , 'COMPUTER HARDWARE' , 'INDIA' , 'XYZ OFFICE' , 'INDIA' , #12/12/1999# , #12/12/1999# , 17420 ,
80 , 50 , 42 , 12 , 0 , '1234-2134'); "
1. Your [G PF] field contains space in its name
2. You're updating [PEN] field with string ABCDE1254W without quotes around it
3. If you seek advice on forums it's in good tone to try, what was suggested maybe?