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

On Mar 2, 2011, at 21:43 , Jean-Francois Nifenecker wrote:

> Le 02/03/2011 21:07, James Wilde a écrit :
> > I can see no way to save my calc as a database under Save as.  I can
> > find no import option in base.  And copying the entire sheet and
> > pasting to the first field on a form doesn't work.
>
> 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?

> 2. Activate the data source pane (F4)

F4 doesn't have any effect on my Mac.  Cmd+F4 closes the sheet.  Shift+Cmd+F4 has no effect.  I 
double clicked on the Base table and got up something that looks like a Calc sheet with only one 
line.

> 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.  :(

But thanks for trying.

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