I need help. Can someone assist me? i am battling to insert items from a list box into a table. Here is my code:
stRecord = "INSERT INTO BatchedFilesTable(PensionNo,SurnameInitials,ChildID,Type,Date,ResCode,District,LocalOffice)" & "VALUES('" & ListOfFiles.Column(0) & "','" & ListOfFiles.Column(1) & "','" & ListOfFiles.Column(2) & "','" & ListOfFiles.Column(3) & "','" & ListOfFiles.Column(4) & "','" & ListOfFiles.Column(5) & "','" & ListOfFiles.Column(6) & "','" & ListOfFiles.Column(7) & "');"
stRecord = "INSERT INTO BatchedFilesTable(PensionNo,SurnameInitials,ChildID,Type,Date,ResCode,District,LocalOffice)" & "VALUES('" & ListOfFiles.Column(0) & "','" & ListOfFiles.Column(1) & "','" & ListOfFiles.Column(2) & "','" & ListOfFiles.Column(3) & "','" & ListOfFiles.Column(4) & "','" & ListOfFiles.Column(5) & "','" & ListOfFiles.Column(6) & "','" & ListOfFiles.Column(7) & "');"