[EMAIL PROTECTED] wrote:
I am using OpenOfice 2.0.
I created a spreadsheet last year entitled "Mailing List"...there is a mall
icon and the word Table 1 which appearswhen I open the document but if I
click on the "Tables" selection top left I get the message..."The connection to
the data source "Mailing List" could not be established."
I cannot open nor find the data entered anywhere. can you help me recover
it?
Thank you...
Beth Veasey
Villageworks
Hi Beth,
From the description you give it sounds like you are opening a file
that is actually a Base file.
What could be happening here is that you created a spreadsheet with Calc
but then when you went to use this in a mail merge you needed to create
a base file so that you could use the data.
This Base file ( it will have the file extension .odf, by the way ) is
actually reading the data from the spreadsheet and delivering to the
word processor when you run the mail merge function. What can happen is
that the location of the actual spreadsheet file might have changed (
hopefully you did not delete it somehow ).
Now if this is actually the case you can check it by doing the following.
Open the file.- look at the lower left corner of the window, if you see
the word spreadsheet then this is a Base file linked to a spread sheet.
So - Before you click on the table icon select the menu
'Edit>Database>Properties'.
On the dialog box that opens you will see a text box with the full path
and file name of the spreadsheet that you linked this to. If that spread
spreadsheet file was moved you can use the Browse button to the right of
the text box to change the setting..
I hope that helps.
Drew
--
OpenOffice.org User Community Forum: http://user.services.openoffice.org
United States PostgreSQL Association: http://www.postgresql.us/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
