Linking and embedding data

WordPerfect lets you link or embed data as WordPerfect content.

You can link or embed data from the following sources:

•
 
spreadsheet
•
 
database (Clipper, dBase, Visual FoxPro, Paradox, ODBC, or ODBC [SQL])
•
 
Web service
•
 
delimited text file (ASCII or ANSI)

In addition, you can specify how the data is imported into WordPerfect:

•
 
as a new table that is inserted into the document
•
 
as regular text that is inserted into the document
•
 
as content for a merge data file
•
 
as a data storage mechanism for macros

By letting you import data from a variety of sources into a variety of formats, WordPerfect supports a number of scenarios for linking and embedding data. Some examples follow:

•
 
You can link or embed spreadsheet data as regular text.
•
 
You can link or embed a database as regular text.
•
 
You can embed data from a Web service by using macro-accessible memory.
•
 
You can link or embed an ASCII delimited text file as regular text.

To link or embed spreadsheet data as regular text

WordPerfect Office btnbacktotopproc Linking and embedding data
1.
 
Click where you want to insert the data.
2.
 
Click Insert WordPerfect Office onestep Linking and embedding data Spreadsheet/Database, and click one of the following:
•
Create link — links spreadsheet data
•
Import — embeds spreadsheet data
3.
 
Choose Spreadsheet from the Data type list box.
4.
 
Choose Text from the Import as list box.
5.
 
Type a path and filename in the Filename box.
If you want to search for the file, click Browse.
6.
 
From the Named ranges list, choose a named range to convert.

You can also
Choose a range to convert
Type a range in the Range box.
Import to a table
Choose Table from the Import as or Link as list box.
Create a merge data text file
Choose Merge data file from the Import as or Link as list box.

WordPerfect Office note Linking and embedding data

•
 
You must remove all passwords in order to import a password-protected file.

To link or embed a database as regular text

WordPerfect Office btnbacktotopproc Linking and embedding data
1.
 
Click where you want to insert the data.
2.
 
Click Insert WordPerfect Office onestep Linking and embedding data Spreadsheet/Database, and click one of the following:
•
Create link — links database data
•
Import — embeds database data
3.
 
Choose a database format from the Data type list box.
4.
 
Choose Text from the Import as or Link as list box.
5.
 
Type a path and filename in the Filename box.
If you want to search for the file, click Browse.
6.
 
From the Fields box, choose the fields to import.
If you want to use fieldnames as column headings, enable the Use field names as headings check box. This option is not available for all data types.
If you want to specify field and record delimiters, click Query. This option is not available for all data types.

You can also
Import to a table
Choose Table from the Import as or Link as list box. If you want to automatically size table columns, enable the Size table columns to fit data after import check box.
Create a merge data text file
Choose Merge data file from the Import as or Link as list box.

WordPerfect Office note Linking and embedding data

•
 
If you are importing an SQL database, you must first log in to the database server.
•
 
You must remove all passwords in order to import a password-protected file.

To embed data from a Web service by using macro-accessible memory

WordPerfect Office btnbacktotopproc Linking and embedding data
1.
 
Click where you want to insert the data.
2.
 
Click Insert WordPerfect Office onestep Linking and embedding data Spreadsheet/Database, and click Import.
3.
 
Choose Web service from the Data type list box.
4.
 
Choose Data storage from the Import as list box.
5.
 
In the Data storage name box, type a name for this instance of macro-accessible memory.
6.
 
In the WSDL filename box, type the URL of the Web Service Database Language (WSDL) file that you want to use to create your Web query.
If you want to search for the location, click B
rowse.
The Configure Web Service Query dialog box appears if the WSDL file that you have chosen is valid. If this dialog box does not appear, click Configure to continue.
7.
 
In the Configure Web Service Query dialog box, confirm that the URL of the WSDL file that you want to use is displayed in the WSDL filename box.
If you want to search for the location, click Browse.
8.
 
From the Operation list box, choose the binding and associated operation that you want to use for the Web query.
If the selected WSDL file has only one associated operation, that operation is automatically selected.
9.
 
In the Query request data area, set up the Web query, and then click OK.
10.
 
From the Fields box, choose the fields to import.
If you want to use fieldnames as column headings, enable the Use field names as headings check box.

You can also
Import to a table
Choose Table from the Import as list box. If you want to automatically size table columns, enable the Size table columns to fit data after import check box.
Embed a text file
Choose Text from the Import as list box.
Create a merge data text file
Choose Merge data file from the Import as list box.

To link or embed an ASCII delimited text file

WordPerfect Office btnbacktotopproc Linking and embedding data
1.
 
Click where you want to insert the text file.
2.
 
Click Insert WordPerfect Office onestep Linking and embedding data Spreadsheet/Database, and click one of the following:
•
Create link — links a text file
•
Import — embeds a text file
3.
 
Choose ASCII delimited text from the Data type list box.
4.
 
Choose Text from the Import as or Link as list box.
5.
 
Type a path and filename in the Filename box.
If you want to search for the file, click Browse.
6.
 
Choose options for delimiters and characters.
If you want to create fields based on the data in the first line, enable the First record contains fieldnames check box.

You can also
Import to a table
Choose Table from the Import as or Link as list box. If you want to automatically size table columns, enable the Size table columns to fit data after import check box.
Create a merge data text file
Choose Merge data file from the Import as or Link as list box. The imported fieldnames are based on the data in the first line.

WordPerfect Office note Linking and embedding data

•
 
Each record must contain the same number of delimited characters (fields).

Linking and embedding data