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

Le 02/03/2011 22:23, James Wilde a écrit :
> > 1. Open Calc and the sheet you want to export to Calc
>
> Is that Open Calc and the sheet you want to export to Base?

well, yes, indeed :)
> > 2. Activate the data source pane (F4)
>
> F4 doesn't have any effect on my Mac.  Cmd+F4 closes the sheet.

Dunno the English menus. Should be smthg like Display/Data sources.

> > 3. Select the data that need to be exported (Ctrl + * will select
> > all the data)
>
> I only selected the columns in the Calc sheet that are equivalent.
>
> > 4. Drag the selection to the left pane of the source pane, onto the
> > database you're targetting. When the table branch is shoiwn, you
> > might see the cursor changing shape
>
> It did indeed change shape.  I got a green + attached to it.
>
> > 5. Drop
> >
> > A wizard should show up. Just follow the directions and you should
> > be all set.
>
> No wizard.  :(

:((

Sorry, I have no clue about LibO/OOo for Mac.

Hopefully someone with a better knowledge of these systems will show up.
--
Jean-Francois Nifenecker, Bordeaux


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