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

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