Need some advice for management field in spreadsheet

[vidago]

Currently, I have 60++ spreadsheet, 10+ record each, and 50-100 fields for each record.

I have 2 method in my mind,

1) create a table for field code, another to store value.
2) create 60++ table with 50-100 fields each.

In terms of search, db maintenance, record maintenance and performance, which would be the best?

In additional, the user may select a range of record based on period and the field they want, for statistic purpose.

Thanks in advance.

[bubblenut]

Well you haven't exactly given us much to go on. What's it for? What's the model?

[vidago]

Ok, basically I need to prepare a system to let the user upload data source from Excel(there are 60++, all in different format), from time to time.

I will use these data, to generate financial report, in quaterly, monthly, half year or 1 year basic, depends on the user search criteria. In additional, user may download these result in csv or xls format.

I am thinking of this method: :eek:
2) create 60++ table with 50-100++ fields each.

but, i am wondering the performance with so much fields in a table in MySQL. Any idea? 😕

Thanks.