a = Convert.ToString(xlssheet1.Cells(j, 1).value) b = Convert.ToString(xlssheet1.Cells(j, 2).value) c = Convert.ToString(xlssheet1.Cells(j, 3).value) d = Convert.ToString(xlssheet1.Cells(j, 4).value) ee = Convert.ToString(xlssheet1.Cells(j, 5).value) f = Convert.ToString(xlssheet1.Cells(j, 6).value) g = Convert.ToString(xlssheet1.Cells(j, 7).value) hs = Convert.ToDouble(xlssheet1.Cells(j, 8).value) ye = Convert.ToDouble(xlssheet1.Cells(j, 9).value)

Dim strsql As String = "insert into ywyb_ls values ('" & a & "','" & b & "','" & c & "','" & d & "','" & ee & "','" & f & "''" & g & "''" & hs & "''" & ye & "')"

Dim oracmd As New OracleCommand(strsql, oraconn) oracmd.ExecuteNonQuery() 执行到最后一句时，提示：其他信息: ORA-00947: 没有足够的值 请问怎样解决？