Re: [libreoffice-users] Import data from spreadsheet to base

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 users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***