On Mar 2, 2011, at 23:20 , Regina Henschel wrote: > Hi James, > > James Wilde schrieb: >> I've checked both LibO and OOo for a how-to or a chapter on this, without >> luck, and I've checked the Nabble interface to the users maillist. >> >> Is there any easy way to get an address list in a spreadsheet into a base >> database? > > Yes, it is easy. > > Version A > You do not have a database already, you want to retain the spreadsheet: > File > New > Database > Connect to an existing database > Choose 'Speadsheet' > Next. > Browse to your Calc document > Next > Finish. > Thanks, Regina, this works. I'll try and live with this method.
> Version B > You have already a database and want to import your speadsheet as new table: > Open the odb-File and go to 'Table' section. Drag the window to half of the > screen. > Open the calc-File, drag its window to the other half of the screen. > Mark your data in the spreadsheet and drag them to the table section in the > data base window. (You ca use the clipboard as well.) This step doesn't work. I mark the entire sheet and try to drag a cell - any cell, they're all marked - into the table section of the odb window, but nowhere does it let me drop with any result. I have, however, found out that it starts working - it's still running in the background as I type - if I have an empty database with no tables. Finished now - "The data content could not be loaded. S1000 General error java.lang.NullPointerException in statement [SELECT * FROM "Medlemmar"]. > Follow the wizard. If you do not want to use the generated primary key, you > have to select one (or more) of your columns to be the primary key in the > second (or third?) step. Use the context menu then. > Do not trust the type detection, but set every type by yourself. > > Version C > You have already a database and want to import your spreadsheet into a given > table. > Nearly the same as in version B, but on the first dialog page of the wizard > you have to choose to append your data. Since B doesn't work, this one is obviously not going to work either. It doesn't. > In the second step you can match the columns of the spreadsheet to the > columns of the data base table. Rearrange the columns in the dialog list of > the spreadsheet source, not in the part of the database table. > //James -- Unsubscribe instructions: E-mail to [email protected] List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
