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. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
