excel sheet to database table

[pms18066]

I have a spreadsheet with row 1 set to role_id
Column a is screen_id
the cells have a code where they meet. see below.

A B C
123 122
Scr1 A D
Scr2 S A

I need to create rows in a database that look like below

Role Screen Display Edit Add
123 Scr1 Y Y Y
123 Scr2 N N N
122 Scr1 Y N N
122 Scr2 Y Y Y

Is there a SSIS or vba or even .net code that can do this straightforward?

Many thanks for any help!!

 

[pms18066]

btw, I have to use the code and translate it to set the flags correctly. What I dont understand is how to match the row and column cells and create multiple records from each row/column.