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 |
|
Thiyagu_04
Starting Member
37 Posts |
 Posted - 2011-09-21 : 05:18:17
|
| 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------------ zContract 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 some 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. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-21 : 06:13:35
|
| can number of locations vary each time in file? or is it static?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Thiyagu_04
Starting Member
37 Posts |
Posted - 2011-09-21 : 07:21:25
|
| Locations will vary in each time in file |
|
|
|
|
|
|
|
|
Need help on designing database