SQLInsertCommand = "INSERT INTO " & strFileName2 & "_ (TRANDATE,[HOUR],SALES,TRANCNT,TENTNAME,TERMNUM) " & _ " VALUES('" & Format(CDate(dr("dateid")), "Short Date").ToString & _ "','" & "" & dr("dhour") & "'," & _ Format(dr("amt"), "########0.00;-########0.00") & "," _ & Val("" & dr("ctrno")) & ",'" & _ LeftX(TenantCode & "-" & TerminalNumber, 15) & "'," & _ "" & dr("tenantcode") & ")" Dim cmd1 As New OleDb.OleDbCommand(SQLInsertCommand, dBaseConnectionB) cmd1.ExecuteNonQuery()
The INSERT INTO statement contains the following unknown field name: 'HOUR'. Make sure you have typed the name correctly, and try the operation again.
The INSERT INTO statement contains the following unknown field name: 'HOUR'. Make sure you have typed the name correctly
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)