Can i add array to single field in MS-Access Database ?

Question

Hello , I've an access database. i want to create a column in my table in which fields can store array or collection of strings or numbers etc.. For example i created a table Cars : Model (String) , Colors_Available(array of strings). Is that possible in Microsoft Access ? please help .

Answer 1

Hey,

I don't think it is; the alternative is to store it as text separated by comma, and in your code, split it before you access it.

HTH.