I have a excel file that I need to read into SQL into a temp table to be use with other SQL tables.
I can read each column as a field, but the way how I have my data layout, it's making it somewhat complicated.
Currently this is what I have:
SELECT * FROM OPENROWSET('Microsoft.Jet.
, 'Excel 8.0;Database=C:\Excel\User
ls', 'SELECT * FROM [Sheet$]')
Here's how my file format is.
I need to be able to read as followed. Is there a way to structure my query so I can read anything passed "Module" as username and everything under "Module" as the Module name and then the permission like the below example?