Hi Guys,
Been working on something for a while and now have an issue with something in the below statement.
Anyone able to help out?
strSQL = "INSERT INTO tbl_TM1_Volumes ( TM1UniqueKey, Site, Date, Time_Band, Number_of_Exits ) " & _
" VALUES (" & _
"" & Sheet1.Cells(iRow, 1) & ", " & _
"" & Sheet1.Cells(iRow, 2) & ", " & _
"" & Sheet1.Cells(iRow, 3) & ", " & _
"" & Sheet1.Cells(iRow, 4) & ", " & _
"" & Sheet1.Cells(iRow, 5) & " )"
Looks fine to me but still erroring.
Been working on something for a while and now have an issue with something in the below statement.
Anyone able to help out?
strSQL = "INSERT INTO tbl_TM1_Volumes ( TM1UniqueKey, Site, Date, Time_Band, Number_of_Exits ) " & _
" VALUES (" & _
"" & Sheet1.Cells(iRow, 1) & ", " & _
"" & Sheet1.Cells(iRow, 2) & ", " & _
"" & Sheet1.Cells(iRow, 3) & ", " & _
"" & Sheet1.Cells(iRow, 4) & ", " & _
"" & Sheet1.Cells(iRow, 5) & " )"
Looks fine to me but still erroring.