Simplicty and flexibility!


How to Import Data into a DataEase Table





How to Import Data into a DataEase Table

DataEase lets you import data from other versions of DataEase and from other DOS and Windows programs, such as Lotus 1-2-3 and dBASE. You can import data into any database table that has columns defined to match the size and data type of the incoming data:


1- Choose File>>Import. DataEase displays the “Import Data” dialog;

2- Choose the Destination table, then choose the Import file format;

3- Specify the path and filename of the source file;

If the source file is stored in the application directory, you don’t need to specify a path. You can click Browse to search for the source file.
4- Specify whether the source data is organized by Field Name or Field Order;
If the source file includes field names in the first record, accept Field Name (the default). If the first record contains data values, select Field Order. When you import records organized by Field Order, fields in the source file must appear in the same sequence as in the destination table.

5- Specify which characters are used as field and record separators (for Variable Length Text format only).
To specify the character used to separate fields or records, choose the appropriate character from the Field Separator or Record Separator drop-down list in the “Import Data” dialog. If the appropriate character does not appear on the list, select Other, then type the character in the entry box.6. Click Run. DataEase closes the “Import Data” dialog, imports the records, and displays the progress of the import in the Status Bar.


Note: Once you click Run, you cannot cancel or abort an import.


See Also

On the forum about How to Import Data into a DataEase Table


Product: . Written by alembagheri tahmas 07/12/13 at 13:37:32

Hi there,I am trying to use an external MySQL DB in dataease. I have successfully create the ODBC link and added the DB to dataease. I can also access the DB from dataease. Now, just for testing purposes, I am trying to create a simple report b...

Product: DataEase for Windows 7.x. Written by George Washington 11/04/14 at 08:26:17

no se pude exportar ahora archivos a pdf, ni a excel o otros cosa mala. en verdad creo que hace faltaen las versiones anteriores me funcionaba mas o menos bien. le hace falta a los aplicativos que se desarrollan en Dataeasegr...

Product: DataEase 8 Reporter. Written by eduardo paez 02/05/14 at 14:40:11

Thanks. Anyway I'm trying to use this fuction but it seems to me that it doesn't work on 8.2. I tried also in a DQL.There's something wrong?<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA9IAAAJ3CAYAAAB4NWk3AAAAAXNSR0IArs4...

Product: . Written by Marco Marchesi 15/02/16 at 14:50:46


Product: Dataease [{8}]FIVE. Written by Chamil Rajindra 21/02/19 at 10:17:46

Thanks for the very good explanation!AS...

Product: . Written by afonso santos 28/10/19 at 00:50:14

I am pleased to see that the migration from Dos 4.53 is then sa 5.5 works. A really useful thing would be a compiler of SQL languages. Will you get there?Original Text:Mi compiaccio a vedere che la migrazione da Dos 4.53 รจ poi sa 5.5 funzio...

Product: . Written by Grossi Gioacchino 18/11/19 at 14:33:44

On the blog about How to Import Data into a DataEase Table