August 8, 2011 at 2:00 pm
Hi Guys,
I need suggestion on what is the best approach to do something like this:
We have some excels files for historical data. First two columns in excel files are keys and for this combination there are several indicators.
Number of indicators in each file can be different...
Example-
Excel1
Country1, Country2, Indicator1, Indicator2, Indicator3
Excel2
Country3, Country4, Indicator1, Indicator2, Indicator3, Indicator4
What I need to do is load the historical files (10 altogether rite now) and create something they can use in future to load values for those indicators for each keys.
Potential Solution:
1. I was thinking to create a normalized database with all possible indicators.
2. Create parameterized SSRS reports using Stored Procedure that they can use to input those Indicators going forward so that I do not have to load those excel files. So the report will have all the possible indicators.
3. They wanted to use MS ACCESS... Maybe I should provide them ACCESS forms which they can use to insert data into SQL Server tables?
Guys what do you think is the easiest solution as we only have couple of weeks to do this...
Thanks!
August 8, 2011 at 2:17 pm
I think the better solution is the normalized database with SSRS. I would not do it in Access.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 8, 2011 at 2:20 pm
Thanks a lot for your response.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply