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 |
|
sillylady
Starting Member
13 Posts |
 Posted - 2007-01-14 : 03:14:40
|
I have an excel sheet like and i want to convert into table. Any help pls?Ratio 1 2 3 4 5Profitability NIM 20% UL 10 7.49 5.49 3.49 2.49 LL 7.5 5.5 3.5 2.5 1ROAA 30% UL 50 39 29 19 9 LL 40 30 20 10 0ROAE 30% UL 50 39 29 19 9 LL 40 30 20 10 0 Asset Quality Gross NPL 50% UL 50 39 29 19 9 LL 40 30 20 10 0Net NPL 50% UL 9 19 29 39 50 LL 0 10 20 30 40 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
sillylady
Starting Member
13 Posts |
Posted - 2007-01-14 : 06:55:36
|
quote:
Originally posted by Peso
Read about OPENROWSET here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926Peter LarssonHelsingborg, Sweden
Peso i think u got me wrong. How can i convert this excel structure in meaningful table. I want a table structure based on this given excel sheet. |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-14 : 15:04:23
|
| No, I did not get you wrong.There are examples of how to READ excel files too...Peter LarssonHelsingborg, Sweden |
|
|
|
sillylady
Starting Member
13 Posts |
Posted - 2007-01-14 : 23:20:16
|
quote:
Originally posted by Peso
No, I did not get you wrong.There are examples of how to READ excel files too...Peter LarssonHelsingborg, Sweden
I don't want to convert this excel sheet into a table as it is. I want to convert this excel structure in meaningful table. I want a table structure based on this given excel sheet. There are 2 groups "Profitability" and "Asset Quality" each group has different ratios (like NIM), each ratio has a weightage (like 20%) then each ratio has UL (upper limit), LL (lower limit) and based on the upper & lower limit there is a point between 1 to 5. |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-01-15 : 06:39:04
|
| So this is a "How do I design tables to support data like shown" question?I think you need to follow up on "Data Design Class 1"....and read any books you can get on this large topic and also try to get some classes/practice and build up to the level required to solve this.You could also explain in simple terms, what the data you are looking at relates to, where it comes from (ie is it a summary of something else) and how each piece interacts with the others....we may be able to piece together something to get you started. |
|
|
|
|
|
|
Table confusion!!