I have an already existing spreadsheet in open office, and I would like to import it into an already existing open office writer doc.

so it would look like:

text
text
spreadsheet
text
text

all nice and clean.
I already tried pasting the info, but it doesn’t work, and tried opening columns in the writer, but I’d like not to have to type it all over in the provided columns. any ideas?
I forgot to mention that I would like the spreadsheet to be smaller then the text in the text doc. because the spreadsheet is long, and it needs to be condensed to fit.