Import Data from MS-Excel
Its posible 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 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))