Quickly entering thousands of lines

[juliorevka]

I have three account types, 110 fiscal months, seven types of fees each associated with a cost. That's 2310 pieces of data if I enter the information with the collumns: AccKey, DateKey, FeeDesc, FeeCost (e.g. For account type one on Fiscal month Jan '11, an overdraft fee was $10). I have all the data on an excel sheet, but it is formatted so that each fiscal year is separate. Is there a way for me to enter this info quickly?

[alansidman]

Without seeing the layout of the excel sheet it is difficult to give you a good answer. Are you able to reformat your excel sheet to allow for an easy import of the data? That would be my first attempt.

but it is formatted so that each fiscal year is separate.

What does this mean?

Alan