Inserting Array to an OLE object field in access database

[Doicare]

Hi all

I am facing a problem in storing an array of integers to an OLE object field in the database, I am trying to place an array in a single field, the field data type is OLE Object.

The error I get is "Type Mismatch" at the bold & underline code line listed below.

Kindly advice.

Sub Import_data()



Dim oAccesss As New ADODB.Connection
Dim oRecordset11 As New ADODB.Recordset
oAccesss.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:\DBS.mdb;"
oRecordset11.Open "Select OLEdata From Table1", oAccesss, adOpenKeyset, adLockOptimistic

Dim SS(10) As integer



For N = 0 To 9

SS(N) = rnd
Next N

With oRecordset11
.Fields.Item(0) = SS

.update

end with

oAccesss.close
oRecordset11.close

End sub

 

[vbajock]

Why are you doing this? How exactly is an array an OLE object?