[libreoffice-users] Re: Link Base to External Spreadsheet

Le 17/02/2013 02:38, Mark LaPierre a écrit :

Hi Mark,


> Now how do I create non-linked tables inside the same DB?
>
> How do I link to another external spreadsheet using the same DB?


You would be better off using an external HSQLDB instance to link 
directly to text tables (note that these would not be Excel files). See 
the HSQLDB manual for how to do this.

http://hsqldb.sourceforge.net/doc/guide/guide.html#texttables-chapter

> Can I link to only one spreadsheet at a time?


In a single ODB file with the embedded hsqldb engine, AFAIK yes.



>  From your email I gather that all tables must be tabs on the one
> spreadsheet that is linked.  Is that a true statement?  Seems pretty
> inconvenient.


It is, fairly. But LO Base is not Access, nor FMPro. If you need to work 
comfortably with and edit multiple separate data sources, using the 
embedded hsqldb is probably not the best choice.

Alex



--
For unsubscribe instructions e-mail to: users+help@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