LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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.

Notices


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

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


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

"data1","data2","data3","data4",etc,etc

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?

thanks
bb
 
Old 07-12-2005, 07:06 PM   #2
bigrigdriver
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 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 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 OpenOffice.org Calc spreadsheet, you can edit it as you want. You have two ways of saving the data in 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.
Check the data range in the OpenOffice.org 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
brickbat
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
 
  


Reply


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
OpenOffice.org Calc Lookup question BorisMcHack Linux - Software 0 01-31-2005 11:49 AM
Text watermarks in OpenOffice.org writer linx win Linux - Software 3 12-27-2004 10:37 PM
OpenOffice.org Calc - Switching Axes in XY graph? apachedude Linux - Software 1 12-05-2004 11:24 AM
OpenOffice.org Calc printing problems Eultza Linux - Newbie 0 09-06-2003 11:33 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

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

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