Re: starting with OpenOffice base

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 spread***... I have split my csv file so as to be able to open each half as a OO Calc spread***, 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 spread***, 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 spread*** 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 spread*** 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 *** was saved.
.

Loading