en-USnl-NL
Goal:
Tick the right boxes in the conversion grid.

Execution:
Tick the box on the crossing of the SQL table fieldname and the Excel datasheet that match:


Because this is a DatabaseBuilder XData sheet, the names of the SQL tablefields and the EXcel colunmnames match is a diagonal path from upper left to lower right.
So it is not a big challenge to create this cross reference.
However, when you use an Excelsheet with data that is derived from another source, it's unlikely that the grid is this well organised. You have to search for the correct fields that have to match.
And beware: Every column and every row in the conversiongrid may have NOT MORE THAN ONE TICKED BOX. It may have NO ticked box however.
If there are more column names in your Excel datasheet, ignore the columns that have NO match in the SQL table, thus creating an EMPY row in your grid.
If there are less column names in your Excel datasheet, ignore the SQL column, thus creating an EMPTY column in your grid.

Empty SQL tablenames will get filled with defoalt data. You have to correct this afterwards in your application......

Test the conversiongrid:
After completion of the datagrid you have to test the grid.
Just click the " Test"  button in the upper-left corner of the grid.
The ExcelReader will now convert the first row of the Excel datashet and display the result in the textboxes just under the SQL tablefieldnames on top.
 

Verify that the conversion is correct. If not, change the ticked boxes accordingly.
If the grid is fine, Click the " Generate All" button. This will convert all the data in the Excel datasheet into your SQL JumpStart DNN table.
(The "Generate One" button is an extra test in case your Excel datasheet contains a great number of records. Once started, you can't stop the conversion, so an extra test could be handy)
     

When the conversion is done the filled SQL JumpStart DNN table will show below the conversiongrid.
    The table is filled with the data.
Now you can close the ExcelReader by un-ticking the box in the settings.

Check the table by clicking the "Select" and "Edit" buttons.
Select Button
Selected record #2
Edit Button

As you can see, all record information is present. Sadly, it does not show in the recordviewer.....
How to solve this is the sbject of the next lesson.

You're done with this lesson.

---->>  Lesson 9: Use the tablefield extentions