You can export data stored in DataEase to CSV file that could then be imported into Microsoft EXCEL.
In order to do that follow these steps (if you are using a different version of Dataease for DOS, the same instructions will vary slightly) :
1- Open your DataEase application;
2- Login with a high level user name and password;
3- Select menu option 4 (DQL Advanced Processing);
4- Select menu option 2 (Start New Procedure);
5- Select menu option 4 (Define Query);
6- Type in the following code replacing the word table name with the name of the table you want to export from; apply the same principle for the tables fields
7- Press to compile the procedure;
8- Select menu option 5 (Define Format);
9- Select menu option 7 (Export) when prompted to specify the type of procedure format;
10- Select menu option 6 (Variable length) when prompted to specify the export format;
11- Enter the tilde symbol ( ~ ) as the delimiter for the Field Separator character;
12- Select menu option 2 (Yes) to Include Field Names in the format;
13- Press to compile and return to the procedure menu window;
14- Select menu option 6 (Define Print Style) and set the report destination to Disk;
15- In the Disk Output, filename: type in the location and filename to where you want the file exported to e.g: c:\expodata\export.csv;
N.B. DataEase only allows for a filename to be 8 characters in length (not including the file extension);
16- Press to compile the window and return to the procedure menu window;
17- Select menu option 7 (Save Procedure), to save the procedure;
18- Enter the procedure name in the space provided.
Finally, run the procedure and check the folder for the exported file.You can then open this CSV file in EXCEL.
Published: 15/12/04 - 10:03:03 (Ulrik Jacob Høegh - Krohn)