Hello friends,
since i am new to programming world, i am facing the issue that how can i save the excel data which is in below format to a table having the below strucure.
excel data.
|
9/13/2018 |
9/14/2018 |
9/15/2018 |
9/16/2018 |
9/17/2018 |
productionorder |
3022221 |
STN1 |
STN3 |
STN4 |
STN5 |
3022222 |
STN1 |
STN2 |
STN3 |
STN4 |
STN5 |
3022223 |
STN1 |
STN2 |
STN3 |
STN4 |
STN5 |
3022224 |
STN1 |
STN3 |
STN4 |
Table Structure.
column name |
datatype |
ID |
int |
production_order |
nvarchar(50) |
station_id |
nvarchar(50) |
to_creation_date |
datetime |
could you all please help me out. thanks alot.