Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


Am 25.07.2011 15:32, Tom Davies wrote:
Hi :)
I think i would approach this by using a database program rather than importing
into a spreadsheet program.  A database program such as Base should be able to
read the text-files directly.  Queries, Forms and Reports can be set-up to do
the required calculations.


Right, a Base makes text import into office documents easy. You can specify the delimiters and everything once for ever and use the resulting database connection in all documents. There are 2 ways. One uses Base for trivial read-only access to a whole directory of csv files. The second method is less trivial and utilizes the built-in HSQLDB (or some other connected database server) to bind one particular text file to one particular database table for full database access.

Example with 5 files demonstrating several use cases with HSQLDB, Base and Calc: http://user.services.openoffice.org/en/forum/viewtopic.php?f=100&t=23727


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.