As far as I'm aware (someone on the list will correct if I'm wrong) you cannot do this in either 1.1.4 or 2.0Beta releases.
One thing you can do is save the spreadsheet file as a delimited file then import into mysql using sql statements. Data entry is easier if a form is constructed, but don't think you can simply import from a spreadsheet into mysql. /paul On 5/24/05, Nat Gross <[EMAIL PROTECTED]> wrote: > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
