I think I have it worked out. Thanks On Mon, Jul 25, 2011 at 10:34 AM, Alexander Thurgood < [email protected]> wrote:
> 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 > -- 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
