Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 07-12-2005, 02:43 AM   #1
LQ Newbie
Registered: Sep 2004
Posts: 8

Rep: Reputation: 0 can't use text database in calc or base

Hi, I have a Comma delimited text file in the format


In oocalc When I do insert/link to external data and select the file, and select comma delimited. I click ok then it returns me to the file selection box but "ok" os not selected so I can't use the database. I tried in version 1.1 and also 2.0 beta. It does it in both. What am I doing wrong?

I also tried doing it in the Base application I can get the database but it gives me one row for all the data even though I selected csv and the commas are there and there are linebreaks.

Any suggestions please?

Old 07-12-2005, 07:06 PM   #2
LQ Addict
Registered: Jul 2002
Location: East Centra Illinois, USA
Distribution: Debian stable
Posts: 5,908

Rep: Reputation: 355Reputation: 355Reputation: 355Reputation: 355
Importing Data Into
To exchange data in a text format use the Calc import/export filter.
1.Export the desired data from the source database in a text format. The CSV text format is highly recommended since it separates data fields by using commas and records by inserting line breaks.
2.Open the data with the "Text CSV" file filter. Select this file filter in the Open dialog in the Files of type list box. Select the file and click Open.
3.You will see the Import text files dialog. Here you can decide which data to include from the text document.
Once the data is in a Calc spreadsheet, you can edit it as you want. You have two ways of saving the data in a data source:
Save the current 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.
Check the data range in the Calc spreadsheet and drag the area into a table container in the data source view. The table container is the area on the left of the database explorer that is designated "Tables" (see diagram). An AutoPilot is started automatically.

Source of this info: OO help screen.

Last edited by bigrigdriver; 07-12-2005 at 07:08 PM.
Old 07-13-2005, 02:43 PM   #3
LQ Newbie
Registered: Sep 2004
Posts: 8

Original Poster
Rep: Reputation: 0
although you didn't quite answer my question, you did provide me with an alternative solution. Thanks


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
OpenOffice Calc Text to Number pokergeek Linux - Software 1 03-29-2012 10:13 AM Calc Lookup question BorisMcHack Linux - Software 0 01-31-2005 11:49 AM
Text watermarks in writer linx win Linux - Software 3 12-27-2004 10:37 PM Calc - Switching Axes in XY graph? apachedude Linux - Software 1 12-05-2004 11:24 AM Calc printing problems Eultza Linux - Newbie 0 09-06-2003 11:33 AM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 12:12 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration