Brian wrote:
Nat Gross said the following on 5/24/2005 11:38 AM:
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.
I really don't think it comes much simpler than that. Export to .csv,
then import to database.
As others have pointed out, you would have to do this for each table,
but it's pretty much an automated process from the database end.
I regularly import/export between OOCalc, MSExcel, and MSAccess, with
occassional excursions into dBase, and bulk transfers go quite smoothly.
Brian
Thanks. I will then have to utilize macros. Not bad.
-nat
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
