Thanks Jeff,

I looked at your spreadsheet. Are you talking about a small application there

a teacher wants to register scores for the students?

During a period more students, subjects and months will be added to the spredsheet.

I use SSIS but I would not use SSIS for this kind of application.

Excel is an excellent front end to a database (for registration and to present data).

I use VBA and ODBC (OLE DB). A table (there you can add rows and columns)

with values in Excel can be inserted in a normalized table as wanted with some coding.

Maybe a sheet there you register new students and subjects is recommended.

To analyse the data I use PowerPivot.

Gosta M