Hi Tony, > First task was to set up tables and transfer data. I did this by extracting > from MySQL as a CSV and opening it in Calc. I then had much trial and error > trying to transfer it into the database.
You could also create a CSV-based database (File|New|Database, "Connect to an existing ...", Type = Text), the open this database and your target database, and drag'n'drop or copy'n'paste your tables. > By chance, I hit on the following - not sure if this is the recommended > method. > > 1. Select All in spreadsheet and Copy. > 2. in database document, select table, then Paste Special from context menu. > 3. in dialogs, edit table name, select Append Data, accept default field > equivalents, then Create. It's a completely valid method :) > 1. If I've just created the table, I seem to need to close the database and > re-open it before using it. I get a message when doing Create Special, > something to the effect that the table is not defined (sorry, can't remember > exact text). Do you mind submitting an issue for this? > 2. The first record of the selection never seems to make it onto the > database. > (Solution: if possible, insert an empty row at the top of the spreadsheet) This is because the data in real is transfered in some table format (Calc puts an HTML or RTF table into the clipboard, and Base extracts and analyses this format), and the first table row is interpreted as header row. There's no possibility to tell Base to *not* expect headers in the table, but feel free to submit an Request for Enhancement. > 1. Forms created with wizard always seem to have Read-only in the title. In > the case of Datasheet forms, this seems to be an accurate description! I > never managed to enter anything. The title problem is known, the "readonly" is strange in some situations. For you not being able to enter anything, this needs more information - normally you're always able to enter data with the form, as long as the database allows so. General exceptions are spreadsheet- and text-based databases, which don't allow modifications to the data per se. > 2. The Forms toolbox seems to pop up from time to time, even when I don't > actually have a database open. Hmm, never heard anything like this. Do you have an idea under which circumstances this happens? Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
