As a database software, visual foxpro5.0 not only provides the ability to manage its own data, but also can be integrated with other applications to obtain the data provided by other applications. In addition, through VisualFoxPro5.0, you can also combine data in tables or views with Microsoft Word documents to generate mail merge documents or embed common fields or link other O VFP
As a database software, Visual FoxPro 5.0 not only provides the ability to manage its own data, but also can be integrated with other applications to obtain the data provided by other applications. In addition, Visual FoxPro 5.0 can also be used to merge data in tables or views with Microsoft Word documents to generate mail-merged documents or embed or link other OLE objects through common fields.
1. import data
Importing data means copying data from another application, creating a new table in Visual FoxPro 5.0, and filling the table with the data in the source file. In Visual FoxPro 5.0, you can import data of multiple file types.
If you want to use tables in FoxPro or dBASE files, you can directly open and use them without importing them. Visual FoxPro 5.0 will ask if you want to convert the table to Visual FoxPro 5.0 format. Once a table is converted from a previous version to the latest version, it cannot be opened later. When importing data, you can either use the import wizard or the import dialog box.
2. append data to an existing table
In addition to importing data to a new table, you can import the data to an existing file. When you select to import data to an existing file, Visual FoxPro 5.0 will append the data to the end of the existing file.
In addition to appending data to an existing file by using the import wizard, you can also use the append source dialog box to append data. When you use the "append source" dialog box to append data, you must first open the table to append records from the "browse" window. By default, Visual FoxPro 5.0 adds all records and fields in the source file to the currently opened table, but uses the "append source" option to specify the fields or records to be appended.
3. export data
In Visual FoxPro 5.0, you can not only import or append data from other applications, but also export the data stored in the Visual FoxPro 5.0 table to another format file, for use by other applications. Export refers to copying data from the Visual FoxPro 5.0 table to the files used by other applications. In the Visual FoxPro 5.0 database, data can be stored as multiple file types.
In Visual FoxPro 5.0, you can use the export dialog box to export data. When exporting data, you can export all fields and records in a specified table, or only a part of them. You can define the fields and records to export.
4. create a mail merge file
We know that using the "mail merge" function in the "Tools" menu in Word can link standard text to a list of single information to form a new document, includes letters, envelopes with addresses, emails, and fax documents. In Visual FoxPro 5.0, the preceding functions can also be completed using the mail merge wizard.
The mail merge wizard integrates Visual FoxPro 5.0 and Microsoft Word applications so that Microsoft Word can share data contained in Visual FoxPro 5.0 tables or views, use the data to print a batch of documents in the same format. In daily life, this method is very useful.
5. embed or link an OLE object
The preceding methods only allow Visual FoxPro 5.0 to share the data generated by other applications statically. To dynamically share data generated by other applications, Visual FoxPro 5.0 also provides an embedded or linked data method. Data embedding and linking are implemented through general fields. Users can embed or link data of other applications in tables or forms through general fields, at the same time, those applications are still used to maintain the data. In Visual FoxPro 5.0, external data is usually embedded or linked to a table or form.
