Please help me with this insert statement

Hi ALL

Please help me with this sql statement it simply doesn't do anything or show any sql errors even though i'm printing the sql statement at the end... might be something very obvious for someone...

sSQL = "INSERT INTO TABLE1 (o1_purchaser_of_equipment,o2_site_address1,o3_M,o 3_L1,o3_L4,o3_P1,o3_L2,o3_L5,o3_P2,o3_L3,o3_Arbitr ations,o3_Not_Known,o4_Commission,o5_Your_Order_No ,o5_Day,o5_Month,o5_Year,o5_Protec_Sales_No,o5_Yes No,o5_Your_Order_No2,o5_Day2,o5_Month2,o5_Year2,o5 _Protec_Sales_No2,o6_Model_no_line1,o6_Description _line1,o6_Qty_line1,o6_Model_no_line2,o6_Descripti on_line2,o6_Qty_line2,o6_Model_no_line3,o6_Descrip tion_line3,o6_Qty_line3,o6_Model_no_line4,o6_Qty_l ine4,o6_Model_no_line5,o6_Description_line5,o6_Qty _line5,o6_Model_no_line6,o6_Model_no_line6,o6_Qty_ line6,o6_Model_no_line7,o6_Description_line7,o6_Qt y_line7,o6_Model_no_line8,o6_Description_line8,o6_ Qty_line8,o6_Model_no_line9,o6_Description_line9,o 6_Qty_line9,o6_Model_no_line10,o6_Description_line 10,o6_Qty_line10,o6_Model_no_line11,o6_Description _line11,o6_Qty_line11,o6_Model_no_line12,o6_Descri ption_line12,o6_Qty_line12,o6_Model_no_line13,o6_D escription_line13,o6_Qty_line13,o6_Model_no_line14 ,o6_Description_line14) "
sSQL = sSQL & "(o6_Qty_line14,o6_Model_no_line15,o6_Description_l ine15,o6_Qty_line15,o6_Model_no_line16,o6_Descript ion_line16,o6_Qty_line16,o6_Model_no_line17,o6_Des cription_line17,o6_Qty_line17)"
sSQL = sSQL & "VALUES('" & o1_purchaser_of_equipment & "','" & o2_site_address1 & "','" & o3_M & "','" & o3_L1 & "','" & o3_L4 & "','" & o3_P1 & "','" & o3_L2 & "','" & o3_L5 & "','" & o3_P2 & "','" & o3_L3 & "','" & o3_Arbitrations & "','" & o3_Not_Known & "','" & o4_Commission & "','" & o5_Your_Order_No & "','" & o5_Day & "','" & o5_Month & "','" & o5_Year & "','" & o5_Protec_Sales_No & "','" & o5_YesNo & "','" & o5_Your_Order_No2 & "','" & o5_Day2 & "','" & o5_Month2 & "','" & o5_Year2 & "','" & o5_Protec_Sales_No2 & "','" & o6_Model_no_line1 & "','" & o6_Description_line1 & "','" & o6_Qty_line1 & "','" & o6_Model_no_line2 & "','" & o6_Description_line2 & "','" & o6_Qty_line2 & "','" & o6_Model_no_line3 & "','" & o6_Description_line3 & "','" & o6_Qty_line3 & "','" & o6_Model_no_line4 & "','" & o6_Qty_line4 & "','" & o6_Model_no_line5 & "','" & o6_Description_line5 & "','" & o6_Qty_line5 & "','" & o6_Model_no_line6 & "','" & o6_Model_no_line6 & "','" & o6_Qty_line6 & "','" & o6_Model_no_line7 & "','" & _
sSQL = sSQL + o6_Description_line7 & "','" & o6_Qty_line7 & "','" & o6_Model_no_line8 & "','" & o6_Description_line8 & "','" & o6_Qty_line8 & "','" & o6_Model_no_line9 & "','" & o6_Description_line9 & "','" & o6_Qty_line9 & "','" & o6_Model_no_line10 & "','" & o6_Description_line10 & "','" & o6_Qty_line10 & "','" & o6_Model_no_line11 & "','" & o6_Description_line11 & "','" & o6_Qty_line11 & "','" & o6_Model_no_line12 & "','" & o6_Description_line12 & "','" & o6_Qty_line12 & "','" & o6_Model_no_line13 & "','" & o6_Description_line13 & "','" & o6_Qty_line13 & "','" & o6_Model_no_line14 & "','" & o6_Description_line14 & "','" & o6_Qty_line14 & "','" & o6_Model_no_line15 & "','" & o6_Description_line15 & "','" & o6_Qty_line15 & "','" & o6_Model_no_line16 & "','" & o6_Description_line16 & "','" & o6_Qty_line16 & "','" & o6_Model_no_line17 & "','" & o6_Description_line17 & "','" & o6_Qty_line17 & "')"
connADO.Execute sSQL
debug.print sSQL


Any help is much appreciated....


Regards,

Is this in an ASP, .NET, etc... application???

hi, this is an asp application with access 2000 as backend...

hi, this is an asp application with access 2000 as backend...

do this

Then post the following.
1) The text that is displayed from the code above.

2) The data types of your database fields.