Hi,

I had similar issue some months ago.

Your description is fine. There are always ways to realize something.

First.

I would like to comment about your DateTable and SiteTable

Why additional tables? You could just store a long-format of date in a column and then use the YEAR, MONTH, DAY … and the many other functions and options with them. In your queries you will have more frequently these functions, and it is not generally a problem.

In your way, by dividing the data into more tables, the update would be more complex rather than using just one table as your sheet is. I usually use to insert sheet’s data in a table with same order of fields. That showed as very practical to me, not only for cases like this one, but also in SSIS and/or DTS.

Second.

However, you could design a SSIS package to transform the data from your sheet and to insert it into a set of normalized tables.

How frequently do you need to update your sql table(s)? If once monthly then you’re all right, if weekly or daily, then you should develop an application.

Regards

IgorMi