Andrew Douglas Pitonyak wrote:
Enrique Castro wrote:

Hi,
While experimenting with mail merge using a Calc spreadsheet as data source,
I have realized that I do not know how to manage data sources in OOo 2.0.

The Help system claims that there is a many item Tools>Data sources to open
de Data Source Administration dialog. Indeed, that menu item is by the
Bibliographic database menuitem in 1.1.x. However I cannot find it in
OOo2.0. I have tried to add a new data source in the View>datasources pane,
but without success.

How are data sources managed in OOo2.0? Are they controlled through Base
exclusively? In Base I have seen how to add a new database, but not how to
use an existing spreadsheet.

Thanks in advance

Enrique
In 2.0, every data source corresponds to a "Base" file.


Am I to understand from this that now I'll have to create a new step to create/register data sources, that of converting spreadsheets to "Base" files? If I convert a Filemaker Pro export file to Calc, will I then also need to convert to Base before I can use the data as a source? Or is there any chance OO/Base will be able to open a Filemaker Pro file directly, or it an FMP output (e.g. dBase, but I don't know how good the Filemaker dBase export is...)? ODBC doesn't work b/c as far as I can tell ODBC ignores FMP found sets and connects to the entire database, but the found sets from Filemaker would be very difficult to recreate as they are done across related files in FMP.

Or if I already have a method for converting FMP outputs to Calc spreadsheets and using those for data sources, will I still be able to use that approach without adding a second conversion from Calc to Base?

Carl


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to