Saving in table (1 Viewer)

france

New member
Local time
Today, 16:57
Joined
Jan 26, 2020
Messages
8
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) & "');"
 

June7

AWF VIP
Local time
Today, 06:57
Joined
Mar 9, 2014
Messages
5,425
You should start your own thread instead of hijacking an old one. New threads get more attention.

Date/time fields need # delimiter for parameters, number fields do not need delimiter.
 

isladogs

MVP / VIP
Local time
Today, 14:57
Joined
Jan 14, 2017
Messages
18,186
Welcome to AWF, France.

Agree with June and have now moved both posts to a new thread.
 

Users who are viewing this thread

Top Bottom