Saving in table

[france]

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]

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]

Welcome to AWF, France.

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

 

[france]

Thank you i will so.