OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Importing from an Appleworks6 (Mac OS X 10.3.9) database

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
billjonesronald
Newbie
Newbie


Joined: 25 Feb 2006
Posts: 3
Location: Ronald, WA

PostPosted: Sun Feb 26, 2006 10:34 am    Post subject: Importing from an Appleworks6 (Mac OS X 10.3.9) database Reply with quote

2-26-06

Anyone have any experience in this? Am new OOo 2.0.1 user.
Just curious is all. Searched on "appleworks" and got no threads.
Back to top
View user's profile Send private message AIM Address
james_h
Super User
Super User


Joined: 05 Nov 2005
Posts: 883

PostPosted: Mon Feb 27, 2006 9:48 pm    Post subject: How to: convert AppleWorks 6 database to OOo 2 Reply with quote

How to: convert AppleWorks 6 database to OpenOffice.org 2 format

OpenOffice.org cannot open an AppleWorks database file directly. You need to use AppleWorks to save the file in a generic data format called "tab separated values", or TSV for short.

Exporting a database from AppleWorks 6 database

Open your database and add the titles of the headings as the first record.
File > Save As...
Pick a file name, and add the following file type extension: .txt (i.e.: Contacts.txt).
Set the file format as ASCII Text
Click Save
Email or transfer the TSV file to the computer with OpenOffice.org

Importing a TSV file into OpenOffice.org 2 as a spreadsheet

You can use a OpenOffice.org Calc table as a simple database.

Start OpenOffice.org
File > Open...
Browse to the TSV file you created.
Under File type, choose Text CSV (*.csv; *.txt)
Click Open
Confirm that under Separated by, the Tabs radio button is selected
Click OK
Check and format the columns as required.
Save as an OpenOffice.org document.

Using a TSV file as a database table in OpenOffice.org 2

You can use this method if you want to use the data in a relational database. To find out how,
search the OpenOffice.org help menu for "Text File Connection."
Back to top
View user's profile Send private message
billjonesronald
Newbie
Newbie


Joined: 25 Feb 2006
Posts: 3
Location: Ronald, WA

PostPosted: Mon Feb 27, 2006 10:55 pm    Post subject: Thanks for the help porting Appleworks db to OOo 2.0 db Reply with quote

2-27-06

james_h;

I'll try it.

I have a thread in Setup and Troubleshooting ("Bad UI fonts..." 2-25-06).
Could you take a look at it?

Bill
Back to top
View user's profile Send private message AIM Address
billjonesronald
Newbie
Newbie


Joined: 25 Feb 2006
Posts: 3
Location: Ronald, WA

PostPosted: Sun Mar 05, 2006 2:48 pm    Post subject: "Text File Connection" Need help loading data into Reply with quote

3-5-06
I followed james_h's suggestions on how to import data from an Appleworks database into OOo.
The data resides in OOo as xyz.ods (csv/txt format).
I let the wizard create the simple data base (abc.odb) and a table and a form.
I have read all the help files on "text file connection" plus browsed lots
of other help panels.
I have hyperlinked sheet1 from the above-mentioned ods file in the form.

I AM STUMPED AS TO HOW TO PROCEED. HAVE TRIED MANY THINGS.
CAN I "COPY" THE RECORDS (EACH HAS 4 FIELDS) INTO THE TABLE VIA
THE INPUT FORM? OR, DO I HAVE TO WRITE A SCRIPT OR MACRO OR
SOME SQL CODE?

Any hints would be appreciated. Thanks.
Back to top
View user's profile Send private message AIM Address
Leo
General User
General User


Joined: 10 Mar 2006
Posts: 5

PostPosted: Tue Mar 14, 2006 8:06 am    Post subject: Migrating to OOo frm Appleworks db ,etc.. Any solutions? Reply with quote

I found this thread by Googling
convert appleworks database file

I run Neo Office AND Open Office for X on my mac

Open Office on My Laptop. Confused
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group