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+h...@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
