Storing Integer array in DB

  • Thread starter Thread starter Nikolay Petrov
  • Start date Start date
N

Nikolay Petrov

What is the best method to store an Integer array in MS Access DB

example
class testClass
public ID1 as integer
public ID2 as integer
public Data() as Integer
End Class


db fields:
id - integer
ID1 - integer
ID2 - Integer
Data - ???????

thaks in advance

I need the ID1 & ID2 fields, because I query the db against them.
 
Sounds like a new table with the tried and true one to many relationship

Table1One
OneID (Autonumber PK)
ID1
ID2

Table2
ManyID (Autonumber PK)
OneID
Data
 
Back
Top