To import Excel Spreadsheet to the database first select the destination database in the tree view.
Then click on the Import Excel File menu item from Tools menu. The Import Excel File dialog box will now appear.
Select Excel file to import by using the Browse button.
If the file contains more than one spreadsheet they all will be uploaded to different tables.
If the first row in the Excel file contains field names select "First row is the header" check box. The system will use column names defined in the first row of the spreadsheet when creating the table. Otherwise it will use F1, F2 and so on for column names.
Click the Upload button.