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

There's so far been no message from me saying thanks for solving the problem, mainly because I'm 
having problems with the different solutions and I want to have them all documented before I reply.

Regina's method 1 works.  I get error messages with method 2 and, I think, method 3, and I want to 
run them both again.

As Arnie said, I'll be back.

//James

On Mar 5, 2011, at 00:41 , James Wilde wrote:

> Thanks, Regina.  I'll take a look at it tomorrow.
>
> //James
>
> On Mar 5, 2011, at 00:37 , Regina Henschel wrote:
>
> > Hi James,
> >
> > James Wilde schrieb:
> > > On Mar 2, 2011, at 23:20 , Regina Henschel wrote:
> >
> > > > 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.
> >
> > Do not mark an entire sheet but only the data. I have written a HowTo
> > with pictures for you. Perhaps it makes clear how it should work:
> > http://www.rhenschel.homepage.t-online.de/HowToImportDataFromCalcToBase.odt
> >
> > 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 ***
>
>
> -- 
> 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 ***


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