Nat Gross said the following on 5/24/2005 7:28 AM:
Hi;
Since 2.0 connects so nicely to MySql, and since 2.0 also reads a
spreadsheet as a 'database', it seems logical that you should be able
to save a spreadsheet to a database, with the sheets being the tables.
But, I can't find this functionality from the menus.
Is this possible 'outta the box'? If not, what does it take to get it
done? Can I setup an ooo spreadsheet as a odbc dsn and read it thru
standard java? If so, does ooo expose more capabilities via odbc than
MS Excel? Is there a special odbc ooo driver?
Whew! I though I will ask ONE question. (Well, maybe it really is one
question.)
Thank you all;
-nat
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
A spreadsheet is technically a database because it allows you to store
and access data.
To get your spreadsheet data into ANOTHER type of database you will have
to import it from that other database. This may mean exporting the
spreadsheet data in CSV or tab separated for first.
Brian
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
