hi!

i want to know how to save an array to database.
this is the code im using

rsS2.Open "SELECT * FROM Competencies where Occupation_Title = '" & txtoccp.Text & "'", cn1, adOpenKeyset, adLockOptimistic
    rsS2.AddNew Array("Occupation_Title", "Competencies", "Code"), Array(txtoccp, competency1, code1)
    rsS2.Update

it work ok but two fields in the database are empty:Competencies & Code
competency1 and code1 are textbox control array,they're suppose to handle the array to be save in the database.this is where i need some help.where to put the array.

thanks

mareynell a. cagalitan