On Friday March 09 2007 8:58 pm, John Jason Jordan wrote:
> I sure hope someone is awake and knows how to merge data into a
> Writer document from a Calc document. I started with Access 2000
> data and finally managed to get it into an OOo 2.0.4 Calc file. For
> the life of me I cannot figure out how to get Writer to see the
> Calc file as a source of data that can be merged into the Writer
> document.
>
> The data has 14 fields. I want to merge only five of them, and I
> need to merge them in a different order than they appear in the
> Calc document. Once, a long time ago, I did this in Writer
> 1.something on Windows. A window is supposed to pop up and you can
> select which fields you want. You can even apply styles, and add
> other static text in front of or after each field. I KNOW it can be
> done. But now that I am on OOo 2.0.4 Linux I cannot figure out how.
>
> I also know I am suppoed to do F4 to open the database window. The
> window opens, but I cannot get the Calc document to appear in it. I
> tried creating new databases, but that accomplishes nothing --
> there are four now in the F4 window, and I also can't figure out
> how to get rid of them.
>
> The Help files are not very helpful. All I can find is that what I
> want to do is easy. But the authors of the Help file must have felt
> it was so easy that it wasn't necessary to say how.
>
> I would be eternally grateful if someone could give me step by step
> instructions for getting a Calc file to appear in the F4 window?
There is a section on connecting to a spreadsheet in the Getting
Started with Base. (See
http://documentation.openoffice.org/manuals/oooauthors2/)
In a nutshell,
1) File > New > Database
2) Select "Connect to an existing database" and change that drop down
choice from JDBC to Spreadsheet.
3) Click Next.
4) Browse to your Calc file.
5) Click Next.
6) Click Finish and name your database for the Calc file.
This should place this database in your Data window (F4) with a
table for each sheet of the Calc file.
At this point, click the database in the Data window. Use the
Right arrow to open the listings in the database (Queries & Tables).
Click the + in front to the Tables to open the list of tables. Click
the table you want to use. It's data should appear on the right side
of the Data window.
Now you have two ways to enter information from the table into
Writer.
Click the rectangle in the upper left corner of the table display
on the right side of the Data window. (This is above all the rows and
to the left of all of the columns.) It will highlight the entire
table. It will also highlight two icons: Data to text, and Data to
fields. (You will need Tips checked (ticked) in
Tools > Options > Openoffice.org > General to identify these icons by
putting the cursor over them.)
I think you will probably want to use the Data to text rather
than the Data to fields icon. You will also want to select just the
rows you want to copy to Writer before selecting Data to text. You
will be given some choices as to how you want the data to be entered
into Writer.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
