NoOp wrote:
On 07/05/2007 03:45 PM, Gary Dale wrote:
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.
Perhaps you mean "you should never have to go into Base for this"? Yes,
if you open the .dba file directly in Calc via File|Open, then yes you
can copy multiple columns, etc., with no problem. However, it seemed (to
me anyway) that the symptons Clive was experiencing were those that
occur if you've opened the table in Base and then try to copy to a Calc
spreadsheet. I could be wrong with that assumption... wouldn't be the
first time, but the above *does* work in copying a table from Base.
You may be right - in which case my response should also have alerted
Clive to the problem and given him a simpler solution. :)
BTW: dBASE files end in .dbf. It's a format that won't go away because
it's simple, flexible and well supported.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
