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

re-structuring data-- conversion question

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


Joined: 18 Feb 2005
Posts: 1
Location: Chicago, IL

PostPosted: Fri Feb 18, 2005 10:39 am    Post subject: re-structuring data-- conversion question Reply with quote

Right now I'm working with what used to be a 100-meg access 97 database. After converting it to Access 2002 using Access 2003 (!?) I was able to connect to it using OO.o Base m79. This database is from an older, poorly updated proprietary database. So right now, I've got a whole lot of tables, and no connections between them. Is there any way to create connections between tables automatically?

My end intent is to be able to visually analyze the data. Stored in this database is info like client name, address, business address, phone number, notes, etc. So, each of the individual tables contain info like that, but it is not connected to a client name. Is there any way to auotomatically restore the connections between names and fields? I am not terribly up to speed with either access, or base. The goal of this project at the moment is to be able to set up these pieces of data as "flatly" as possible (possibly CSV) so that I can get them moved into ACT!

Heck, is anyone aware of open-source alternatives to ACT!? I'm trying to track sales, etc. Does anyone have any clues on what I should be doing? I'm just trying to get the database into a "browsable" structure again so that I can set it up for export.

Thanks!

-Jake
_________________
Jacob Anthony Gadikian
Business Technology Specialist,
Student of History and International Studies
716-912-8357
AIM: faddat
SKYPE: faddat
faddat.blogspot.com
Back to top
View user's profile Send private message Visit poster's website AIM Address
acolvin
OOo Enthusiast
OOo Enthusiast


Joined: 14 Dec 2004
Posts: 152

PostPosted: Sat Feb 19, 2005 1:18 am    Post subject: Reply with quote

You could try dbdesigner which is opensource (or similar) and written in Kylix. I can do the analysis for you and create links in the design.

Hope this helps
Andrew
Back to top
View user's profile Send private message AIM Address MSN Messenger
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