Do not let any software impress you!

Only let it convince your intellect.
Slider img 1
Do not look for a business paradise!

It is a waste of time.
Slider img 2
Only yourself can push you uphill.

There is no easy road to prizes.
Slider img 3
Productivity is the name of the game.

And you have to conquer it.
Slider img 4
As long as you understand it,

you will start to build your know-how.
Slider img 5
We can help with that.

We have the tools and the method.
Slider img 6

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))