Re: starting with OpenOffice base

Le Fri, 02 Oct 2009 11:23:31 +0100, The Natural Philosopher a écrit :

Bernard wrote:
Hi there !

My purpose is to work with a database of about 150,000 records. Until
this base reached 65,000 records, I had no problem managing with
OpenOffice Calc, but this now exceeds Calc capacity, this is the only
reason why I intend to try OO base.

Now, I can't find a doc to answer my questions below :

How am I to import a .csv ";" separated text file into base ?
Following the few docs that I found, I did not reach my purpose.
Creating a new "table" using "copy/paste": you have to copy/paste from
a file or spreadsheet... I have split my csv file so as to be able to
open each half as a OO Calc spreadsheet, I import the first half, but
then, how can I insert the second half ? I did not find any insert
function...

Thanks in advance for hints


Importing Data Into OpenOffice.org
To exchange data in a text format use the OpenOffice.org Calc
import/export filter.
1.Export the desired data from the source database in a text format. The
CSV text format is recommended. This format separates data fields by
using delimiters such as commas or semi-colons, and separates records by
inserting line breaks.
2.Choose File - Open and select "Text CSV" from the File type combo box.
Select the file to import and click Open. 3.Select "Text CSV" from the
File type combo box. Click Open. 4.The Text Import dialogue box appears.
Decide which data to include from the text document.
Once the data is in a OpenOffice.org Calc spreadsheet, you can edit it
as needed. You have two ways of saving the data as a OpenOffice.org data
source:
Save the current OpenOffice.org Calc spreadsheet in dBASE format in the
folder of a dBASE database. To do this, choose File - Save As, then
select the File type "dBASE" and the folder of the dBASE database.
Exporting in CSV Text Format
You can export the current OpenOffice.org spreadsheet in a text format
which can be read by many other applications. 1.Choose File - Save as.
2.In File type select the filter "Text CSV". Enter a file name and click
Save.
3.This opens the Export of text files dialogue box, in which you can
select the character set, field delimiter and text delimiter. Click OK.
A warning informs you that only the active sheet was saved.

Thanks for this reminder. I tried this. First problem : anything that
needs to go through OO_Calc must not exceed 65536 records. Even then, I
tried splitting my file, importing one half, then copy/paste the other
half into the table. The first import took about one hour. Once done, I
tried to open the table and go to last record : it will be almost two
hours that I wait till this process comes to an end...

.

Relevant Pages

  • Re: starting with OpenOffice base
    ... How am I to import a .csv ";" separated text file into base? ... 1.Export the desired data from the source database in a text format. ... 3.This opens the Export of text files dialogue box, ...
    (comp.os.linux.misc)
  • Re: starting with OpenOffice base
    ... How am I to import a .csv ";" separated text file into base? ... To exchange data in a text format use the OpenOffice.org Calc import/export filter. ... 1.Export the desired data from the source database in a text format. ... Once the data is in a OpenOffice.org Calc spreadsheet, you can edit it as needed. ...
    (comp.os.linux.misc)
  • Re: How do I import DOS files into Excel?
    ... The old database is running on a machine. ... to try the CSV thing. ... data from the old program into a common format, ... John Nurick [Microsoft Access MVP] ...
    (microsoft.public.access.externaldata)
  • Re: file transfer between Mac and PC
    ... Your first four points are not applicable for me as I used a template ... the field names in the database. ... When you save as a .csv, ... distinction between .csv format for Mac & .csv format for Windows? ...
    (microsoft.public.mac.office.excel)
  • Re: file transfer between Mac and PC
    ... First - make sure the is nothing on the sheet to be exported other than the ... the field names in the database. ... When you save as a .csv, ... distinction between .csv format for Mac & .csv format for Windows? ...
    (microsoft.public.mac.office.excel)