Can one transfer a table of data from a spreadsheet to a FrameMaker Table?

[Fred Tabbutt]

I had hoped that if I highlighted the columns/rows of data on the spreadsheet and copied onto the clipboard and then created the same number of columns and rows in a FrameMaker Table that I could paste them in but Edit>Paste is inactive under these conditions. If I just highlight one cell in the Table, Paste is active but all of the data appears in that cell. Any suggestions? I am using FrameMaker 6.0 in OS9.

[thomas bro]

Fred,

If you copy your data from Excel and others and choose Paste Special/Rich Text Format you'll get a nice table directly in FrameMaker (needs a bit of molding though).

keep smiling
thomas

[R. VanDyke]

You can also use the following techniques to move spreadsheet data from Excel (or any similar program) to FrameMaker:

* Save the spreadsheet as formatted text, copy the text into FrameMaker,
and use FrameMaker's "Convert text to table" option to put the text into
a table.

* Print the spreadsheet via Acrobat Distiller into a PDF, open the PDF in
Acrobat (full-featured, not Reader) to crop as desired, then import the
PDF into FrameMaker.

The second method is one of my favourite ways to import spreadsheet data when the spreadsheet includes formatting I'd like to include as part of the data's presentation in FrameMaker.

Cheers & hope this helps,
Riley

[Fred Tabbutt]

Thank you both for your prompt responses.

While the "Paste Special" solution suggested by thomas would have been my choice it appears that is a Windows only feature. So I tried Riley's "convert text to table" and that worked quite well. The pdf is an intereting possibility which I may use for other tables in the future but in this case I wanted to have the option of modifying an entry after it was in the table.

Thanks for solving my problem.

Fred