Task for the laboratory work (стр. 2 из 2)

Dates in other formats can be imported if their format matches a date format available in SET DATE. To import dates that are not in the default format, issue SET DATE with the proper date format before using APPEND FROM. To test if a date format can be successfully imported, use it with CTOD( ). If the date is acceptable to CTOD( ), the date will import properly.

FW2

FW2 files are created by Framework II. FW2 file names are assumed to have a .FW2 extension.

RPD

RPD files are created by RapidFile version 1.2. RPD file names are assumed to have an RPD extension.

SDF

An SDF (System Data Format) file is an ASCII text file in which records have a fixed length and end with a carriage return and a line feed. Fields are not delimited. The file name extension is assumed to be .TXT for SDF files.

WK3

Data from a Lotus 1-2-3 spreadsheet. Each column from the spreadsheet becomes a field in the table; each spreadsheet row becomes a record in the table. A .WK3 file name extension is assigned to a spreadsheet created in Lotus 1-2-3 revision 3.x.

2.2. OLE.

Another method of data exchange between not only FoxPro but between all Windows based applications is OLE (OBJECT LINKING AND EMBEDDING)

First you can use a FoxPro built in command Append General.

APPEND GENERAL <general field> FROM <file>

[LINK]

[CLASS <ole class>]

APPEND GENERAL is supported in FoxPro for Windows only.

If an OLE object already exists in the general field, it is replaced with the OLE object from the file.

Clauses

<general field>

Include <general field> to specify the name of the general field the OLE object is placed in. You can specify a general field in a table open in a noncurrent work area by including the table alias with the field name.

<file>

Include <file> to specify the file containing the OLE object. You must include the entire file name, including its extension. If the file is located in a directory other than the current default directory, include the path with the file name.

LINK

If LINK is included, a link is created between the OLE object and the file that contains the object. The OLE object appears in the general field but the object's definition remains in the file. If LINK is omitted, the OLE object is embedded in the general field.

CLASS <ole class>

Include the CLASS clause to specify an OLE class for an OLE object other than the default class.

Tip To determine the class for an OLE object, run REGEDIT and double-click on the OLE object. The class name is listed under Identifier.

You can specify a class name when the file extension for the file containing the OLE object is different than the default extension and you want to force the behavior for the class. If the default extension can be used by multiple OLE servers, include the class to specify a particular server.

3. Practical usage of data transfer.

In applications you can find the examples of the above mentioned commands usage and their results in different Microsoft Applications (FoxPro, Word & Excel).

4. Technical facilities & literature used.

During creating this program the following equipment & software was used:

Pentium 100 MHz PC with 8 Mb RAM

Microsoft Windows’95

Microsoft Visual FoxPro 3.0

Microsoft Word 7.0

Microsoft Excel 7.0

Printer Hewlett Packard LaserJet5L

No special literature but build-in HELP of Visual FoxPro 3.0, Word 7.0, Excel 7.0 & useful advices was used to create this laboratory work.

5. Applications.

Application 1 “Transfering data form FoxPro to Word & Excel”

Application2 “FoxPro database converted to Excel (.xls) file”

Application 3 “FoxPro database converted to Word (.sdf) file”

Application 4 “FoxPro base converted in Word file - in Excel”

Application 5 “Excel file in Word”