Re: [libreoffice-users] Re: Importing .xls table into Base

Hi :)
I think Base is best when you keep those tables externally, preferably
in a dedicated database program such as MySql / MariaDb, Postgresql,
HsqlDb or any of the other ones.  Access is not so good at linking to
external sources for it's data so it's quite a radical difference
between Access and Base.  It means Base is much easier to upscale (or
downscale) just by swithcing which back-end program is storing your
data.

The link didn't work very well for me either.  The close-bracket at
the end seems to have grabbed the f which radically changes the
address and just got me something like a "404 Page does not exist"
error.  It might be better to look through the wiki's Faq about Base
https://wiki.documentfoundation.org/Faq
Also the official documentation has a handbook and the 1st 3 chapters
of the guide.
https://wiki.documentfoundation.org/Documentation/Publications

I wonder if the pdf link works better like this?
 * https://wiki.documentfoundation.org/images/e/e8/BH40-BaseHandbook.pdf

Regards from
Tom :)


On 16 December 2013 21:22, dollyp <david@lochnevis.com> wrote:
> julien2412 wrote
> > Taking a look to the documentation, I read this:
> > "Exporting data from Calc into a database
> > Select the data in the Calc worksheet. Hold the left mouse button down and
> > drag the data that you
> > want to turn into a database into the table area of the database browser.
> > "
> > (see
> > https://wiki.documentfoundation.org/images/e/e8/BH40-BaseHandbook.pdf)
>
> Sorry I can't find this info in the document you linked to. There are
> several paragraphs about linking to spreadsheets but that's all I can find.
>
> Nevertheless, thanks to both responders for the information, which proved to
> be what I needed. I would say that for folk coming to Base from Access, the
> lack of a menu option for 'import' does not help. To be fair, select/paste
> is more intuitive and a plus for Base.
>
> Again thanks
> David
>
>
>
>
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Importing-xls-table-into-Base-tp4088116p4088435.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted