New to Access - Need to store 420-element array?

I have some Excel programs that produce data in 420-element arrays. Currently all my data transfer is happening via XML files. However I'd like to be able to store this data in Access to enable some data analysis and querying.

Of course, the problem is that this is too many fields for one table... the data in the arrays are monthly projections going forward 35 years so there's no real logical way to break these up that I can think of. Is there some way to store this data so that it can be easily queried? Thanks.

Wouldn't you have just 2 fields one for the projected date and the other for the projected value, maybe you'd have another field as an fk to the array lookup table so you knew which projections had come from which arrays

Well let me elaborate on my problem a bit more. I have a table of objects and each object is going to have about 12 of these arrays associated with it. I suppose I could have 12 fields in a table, each of which refers to a different array, and then have a table which does what you've subscribed. The problem with that is that I am going to end up creating a LOT of data in the array table (420 x 12 = 5,040 records for each object, and potentially this could grow to thousands of objects...).