Brian wrote:
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.
Exactly my point! (See next comment.)
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.
With Java/jdbc I can connect to two different databases simultaneously
and copy rows to/from each other. No need to export-import. Since, as
you pointed out, a spreadsheet is synonymous with a database (and since
ooo so eloquently treats it as such in the 'base' module), I was hoping
that there was a simpler way to get data over.
Thanks.
-nat
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
