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 |
|
sarahmfr
Posting Yak Master
214 Posts |
 Posted - 2011-11-16 : 23:55:55
|
| I have an excel spreadsheetstudentid exam1 exam2 exam3 lab1 lab2 etc.1 10 20 30 50etc.Note the exam1,exam2,etc can changei.e. the spreadsheets hole studentids and quizes or exams for different sectionsI would like to import them to a tablestudentid assessmentname scorethe assessment names vary from one section to another how to do thatthanksI tried to do the pivoting but each time the excel spread sheet will have different column headers according to the assessment namesThankssarah |
|
|
|
|
|
Excel SpreadSheet to a table