Le 25/07/11 15:32, Tom Davies a écrit : Hi all,
> 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. > Yes, you can bind text files directly to the HSQLDB backend : http://hsqldb.org/doc/guide/ch06.html in order to access them from LibreOffice, you would first need to create an empty ODB database document, e.g. using the Database Creation Wizard. Once the file has been created and saved, close it, reopen it, and then execute the SQL statement provided in the HSQLDB documentation to bind your text tables into the database. The SQL commands are executed from the menu Tools > SQL... and not from the Query UI of the ODB container. Alternatively, open your CSV in Calc, and then copy the whole sheet over to the new DB as a new table. Things to be aware of if you are going the Calc to Base route: - type recognition between Base and Calc is not perfect, i.e. the engine used for type recognition of data types sometimes gets it horribly wrong for certain data types like decimal point containing data, date or date/time data, especially if the locale is not EN-US. - there is a bug in the date calculation engine that appears to cause some dates to be misdisplayed or miscalculated with an offset of 1 or 2 days - this is a recurring old bug that has never been nailed because it was too hard to track down exactly where the problem was coming from. Good luck Alex -- Unsubscribe instructions: E-mail to [email protected] 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
