Import Data from MS-Excel
It is possible to import data from MS-Excel sheets. Goto Database Manager and select 'Import Data'. The steps to be taken are the following:
1) Load the excel sheet into the form by pressing 'Load Data To Grid'
2) Write the table name in the 'Table Name'
3) In the next memo box of the form write the following SQL text:
INSERT INTO CUSTOMER ([NAME], [SALARY]) SELECT '_cell_1', _cell_2
The fields NAME, SALARY must be put in the first line of the imported excel sheet. In the second line of the excel sheet, you can put the data types of the corresponding fields as (STRING, WIDESTRING, MEMO, DATE, DATETIME, INTEGER, AUTOINC, FLOAT).
4) By pressing 'Run' the system starts to execute the SQL command separately for each excel sheet line.
(Caution the first data line must be the (5))