Here are some examples of what you can do with Copy and Paste:
Database è Spreadsheet
Select the rows and columns (the range of fields) you want to copy from the database and copy and paste into a spreadsheet. Ability will preserve the order of the rows and columns and every field from the database will appear in a different spreadsheet cell.
Database è Write
Select the rows and columns (the range of fields) you want to copy from the database, and copy and paste into a Write document. Each column is separated by a tab stop and each row begins on a new line.
If the database row is too long to fit on a single line in the Write document and "wraps around" onto the next line, try bringing the tab stops closer together and/or reducing the font size.
Write, Spreadsheet è Database
This is the reverse of the above two operations. Ideally the number of columns in Spreadsheet – or the number of tab separated columns in Write – should match the number of fields (columns) in your database (if not, you may find that fields from different records merge into a single record).
Write è Spreadsheet
Select the text you wish to copy. This can be a word, a line or several paragraphs. When you paste into Spreadsheet, tabs will begin new columns and paragraphs new rows. Use Paste Special from the Edit menu and select Unformatted Text.
See also: