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.