I have an Access table that I am trying to append records.
It has the following structure
I have read in the values for the variables Action, Person, myDate, Comment, Outcome and Acttno from an Excel table with values of
"Phone Call", "Huw", #14/12/2017#, "blank", "blank", "Ac TEGY-01 006"
but when I try to update the records it fails on the execute line with message "no value given for one or more parameters"
strQuery = "INSERT INTO Actions ([Action], [Person],[Action Date],[Comment],[Outcome],[Act No]) " & _
"VALUES (Action, Person, mydate, Comment, Outcome,Acctno);"
What am I doing wrong?