How to: Insert Data in Tables
You can include data from other applications in a Visual FoxPro table by inserting the data into General fields. For example, if you have pictures of products, you can include them in a table containing other product information by inserting them into a General field. If the quantity of data is small enough, you can copy and paste it into the General field.
To insert data into a General field
Open and browse the appropriate table.
Double-click the General field in which you want to insert the data.
From the Edit menu, choose Insert Object.
The Insert Object dialog box appears listing the types of data you can insert into the field.
Tip
You can save disk space when linking or embedding data by clicking Display As Icon in the Paste Special dialog box. When this is selected, Visual FoxPro displays the icon instead of the data.
Choose one of the following:
- To create data of your own, select Create New and then choose the appropriate type of data.
-OR-
- To use existing data, select Create from File. Then, type the name of the file containing the data, or choose Browse and select the appropriate file. If you want to link to the file, select Link.
To paste data from another application into a General field
In the other application, select and copy the data to the Clipboard.
Open the table containing the General field in a browse window.
Double-click the General field.
Choose one of the following:
- To paste the data, on the Edit menu, click Paste.
-OR-
To link to the data, on the Edit menu, click Paste Special to open the Paste Special dialog box, then click Paste Link.
Tip
You can save disk space when linking or embedding data by clicking Display As Icon in the Paste Special dialog box. When this is selected, Visual FoxPro displays the icon instead of the data.