From excel to Database

Question

HI team, 
 I have a requirement for my quiz application. I Don't have any idea about how to implement.I need some suggestions from u guys. 
 My requirements are, 
 
 when starting the application I have one editable grid which has a chapter name,total question and file upload field 
 In file upload I am using (excel to database ) smart service. when uploading the file means at that time what are all the fields in my excel it have to store the data in the database 
 totally 2 data type one is for main where I am uploading my excel another one is for store the excel data fields 
 
 how to implement this......

Mathieu Drouin · Answer

Basically 1 Record Type: Quiz with 3 columns (id, name, total questions, excelDocumentId) 
 Then you could have another Record Type where you would store the values contained in the Excel file. 
 Quiz_Detail (id, quizId, excelColumn1, excelColumn2 etc.)

Mathieu Drouin · Answer

Use the r eadexcelsheetpaging function in the Excel Tools plugin: community.appian.com/.../excel-tools