NoOp wrote:
On 07/05/2007 01:52 PM, CLIVE SINOFF wrote:
Thanks for the suggestion.
Unfortunately, holding down the shift, the CTRL or both doesn't do it.
Has my database some setting which is preventing me from copy multiple
fields?
I can highlight the entire database by clicking in the upper left
corner, but when I copy, all that appears in the spreadsheet is a
single ID number. Also, I am unable to save the database in a CSV
format, although I could create a report and save that in various word
processing formats.
Is there a way of converting the entire database to excel?
Any other ideas?
Thanks again.
I have never experienced all of this before.
I see exactly what you are talking about (OOo 2.2.1 linux). Here is a
solution:
1. In Base select Tables
2. Click on the table you are interested in, then right click it
3. Select 'Copy'
4. In a clean Calc spreadsheet: Edit|Paste Special
Select the 'Formated Text [RTF] and click OK
That will copy the entire table into the spreadsheet. You'll find that
many of the column headings get merged (A merged with B etc), but that's
OK, you now at least have all of the date in the spreadsheet, so now you
have something to work with. Now do a File|Save As and select Text .csv
& off you go. Don't forget to save it as an ods file as well.
You should never go into Base for this. Everything can and should be
done in Calc.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
