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

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.

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.)
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.
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.

Kind regards
Regina

--
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 ***