Drew Jensen wrote:
[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 ).
Sorry I left Beth off the first response..
and - Beth that file will have an extension of .odb, not odf.
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]
