To turn the workbook files of Excel into VFP results report

The examination is over, the superior department requests to report the result: The field name is the student number, the name, the class, each subject achievement and the total score, the width is 14, 8, 12, 4, 4 respectively. The score and total score requirements are numeric and the rest are character type. The file name is: the school name. dbf. Can the school report the result is the workbook file that Excel 2000 establishes, how to convert the workbook file that Excel 2000 builds to conform to the request VFP performance report?

Using VFP to re-establish performance report, the number of students is large, cumbersome and error prone! Too strenuous, or find another way.

Select VFP "File" menu "open" option, open the workbook file created by Excel 2000, the results show garbled, obviously this method is improper.

Try the import option on the File menu to eject the Import dialog box, as shown in Figure 1, by clicking on the [...] from. button, locate the electronic workbook you want to import, and the result pops up the error dialog box, and you cannot import the workbook files created by Excel 2000 directly.

Figure 1 Finding the electronic workbook you want to import

Can I convert the workbook files that are created in Excel 2000 into Microsoft Excel 5.0 and the format (XLS)? Start Excel 2000, open the Save As dialog box and discover that the save type can be saved as a Microsoft Excel 5.0/95 workbook, and then save the workbook file created by Excel 2000 as a Microsoft Excel 5.0/95 workbook. Then the "import" operation in VFP, the workbook was successfully imported.

In the Command window, enter "list" to see the results of the import, no error! With "List Stru", you find that the field name, type, field width is not required, and you modify the field name, type, and field width in the command window by using the Modi stru command, as shown in Figure 2.

Figure 2 Modifying the width of a field

Modified, with VFP "Export" operation, as shown in Figure 3, so that the requirements of the VFP Results report production completed.

Fig. 3 Using VFP to export