Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ghanta
Yak Posting Veteran
96 Posts |
 Posted - 2011-08-08 : 15:58:59
|
| 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-Excel1Country1, Country2, Indicator1, Indicator2, Indicator3Excel2Country3, Country4, Indicator1, Indicator2, Indicator3, Indicator4What 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! |
|
|
|
|
|
Inserting Data Into SQL Server using Forms/Reports