Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2011

    Unanswered: Need help on designing database tables

    Hi All,

    I am having a requirement like need to upload excel file in application,reading values C# and put into SQL server 2008 database.

    Excel sheet looks like

    FAO Services --------------<<Location 1>> <<Location 2>> <<Location 3>>
    Spend Analysis-------------- X--------------- y------------ z
    Contract Negotiations------- 1----------------2------------- 3
    Strategic Sourcing---------- a----------------b------------- c

    from the above example "FAQ Services",Location 1,Location 2 and Location 3 are column headers instead of Location 1 they enter like "US","UK" etc.. Locations will increase.

    Can someone help me how to design database tables for this requirement.How to save x,y,z,1,2,3,a,b,c are actual values.

  2. #2
    Join Date
    Apr 2008
    Iasi, Romania
    Provided Answers: 3
    FAO (ID, Name)
    Location (ID, Name)
    Values(FAOID, LocationID, Value)
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts