Re: [libreoffice-users] Re: How to import a txt file into an existing Calc sheet?

I think I have it worked out.
Thanks

On Mon, Jul 25, 2011 at 10:34 AM, Alexander Thurgood <
alex.thurgood@gmail.com> 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 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

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