Insert into SQL Tables using SSRS or Access

  • 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!

  • 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

  • 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