LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Desktop
User Name
Password
Linux - Desktop This forum is for the discussion of all Linux Software used in a desktop context.

Notices

Reply
 
Search this Thread
Old 09-11-2006, 05:33 PM   #1
RetiredInMaine
Member
 
Registered: Jun 2006
Location: Maine
Distribution: ubuntu
Posts: 33

Rep: Reputation: 15
Question Need OOo base help


I need to convert a database from MS Access to something I can use in Linux. (In a moment of weakness I took over as Secretary for a club I belong to) I need data base functionality, like views and queries etc. I had the Access db file exported in excel format, opened it in OOo and then opened base and imported it as a dBase format file. Then I created a form using the form wizard. The data is all there. However when I go to open the file it always wants to create a form again. I read (in a book on OOo) that this is standard and that I should go to another OOo function, like Writer, and use File Open to open the file. But when I do that I get a Calc spreadsheet.

I have been trying to find documentation on the base function, with no luck. I have two books on OOo, but the sections on base are way too simplistic, and anyway doesn't seem to match my results. I went to the OOo web site but the documentation for OOo 2.x does not include base documentation.

How do I set up and use queries and views in base? How do I create input forms? I can't get to the form I created when I first imported the data.

Also, what is the dBase format? Is it the old DOS dBase format? Or is it a new linux relational format. The DOS dBase format was not a true relational data Base, I believe it was a linked list of some sort (I used to do a lot of xBase stuff in DOS but I've forgotten some of the particulars) Can I change the base dBase format to a true relational data base format like mySQL?

And does anyone know where I can get solid documentation on base?

Any help will be GREATLY appreciated
 
Old 09-11-2006, 08:09 PM   #2
runnerfrog
Member
 
Registered: Jul 2006
Location: Paraná, Argentina
Distribution: Frugalware 0.6 (Terminus) - Kubuntu 7.04 (Feisty Fawn Herd 5)
Posts: 217

Rep: Reputation: 31
The simplest thing might be connecting from your db client to the db server. If you still can open de DB with M$ Access, may be you can export it to your MySQL server following the steps on this link:
http://www.itc.virginia.edu/desktop/.../msaccess.html
Then you may access it with whatever you want as client.
 
Old 09-11-2006, 08:14 PM   #3
rickh
Senior Member
 
Registered: May 2004
Location: Albuquerque, NM USA
Distribution: Debian-Lenny/Sid 32/64 Desktop: Generic AMD64-EVGA 680i Laptop: Generic Intel SIS-AC97
Posts: 4,250

Rep: Reputation: 60
The lack of an MS Access type database is one of the toughest things about Linux. I have not heard that OO Base is ready. Kexi is another program that claims some Access compatibility, and I have recently been hearing of another program named Knoda. Check them out. If you are willing to work with a real RDBMS, (and that is a big bite to chew), I wrote a tutorial about getting Access data to Postgresql using ReKall. ReKall is a fairly mature front-end patterned after Access, and if you're pretty good at what you're doing, it may be just what you need.
 
Old 09-11-2006, 08:24 PM   #4
RetiredInMaine
Member
 
Registered: Jun 2006
Location: Maine
Distribution: ubuntu
Posts: 33

Original Poster
Rep: Reputation: 15
Thanks, I'll try it

Thanks to both of you. However I have zero MS capability, I am strictly Linux.

I'll check out your tutorial and see if I can get the data transferred over. If Postgresq is sql capable I can handle it.

I'll post my results either way.
 
Old 09-11-2006, 09:10 PM   #5
RetiredInMaine
Member
 
Registered: Jun 2006
Location: Maine
Distribution: ubuntu
Posts: 33

Original Poster
Rep: Reputation: 15
I read the tutorial - some questions

OK, I printed and read your tutorial. Seems straight forward. However I do have a question. If POSTGRESQL is a RDBMS and ReKall is just a gui front end, why do you say that POSTGRESQL can't access a db created by ReKall?

I have never worked with POSTGRESQL but don't the tables exist in a POSTGRESQL data base? If I need to do something with the data that ReKall can't handle, shouldn't I be able to do it just about anything I need with just plain sql?

And to anyone following this thread, I'd still like to solve my OOo problems because at some point in the future I'm going to have to reverse this process and give the data to someone who only has MS software.

Stay tuned, I'm going to install POSTGRESQL and ReKall and try to move the data over.
 
Old 09-12-2006, 09:28 AM   #6
RetiredInMaine
Member
 
Registered: Jun 2006
Location: Maine
Distribution: ubuntu
Posts: 33

Original Poster
Rep: Reputation: 15
Question The big question I forgot to ask

I forgot to ask, if I do the work of converting my data to postgresSQL, can OOo read it for merge operations? After all, that's really the most impotant reason I need to get it into a db format, so I can run a query to create a view, and then create a mailing from it.
 
Old 09-12-2006, 12:36 PM   #7
runnerfrog
Member
 
Registered: Jul 2006
Location: Paraná, Argentina
Distribution: Frugalware 0.6 (Terminus) - Kubuntu 7.04 (Feisty Fawn Herd 5)
Posts: 217

Rep: Reputation: 31
Sorry to interrupt. May be this can help some way: Yesterday after I read your problem, I just checked how I can solve it in the easiest & fastest way, well, I created a MS Access relational db and I used the MySQL Migration Toolkit that is included in the MySQL GUI Tools Bundle; I selected the Access DB, then I selected the MySQL server, and... done (everything under GNU/Linux), and it work migrating both ways with several other relational kind DB types.

MySQL GUI Tools Bundle, download from:

http://dev.mysql.com/downloads/gui-tools/5.0.html

Last edited by runnerfrog; 09-12-2006 at 12:39 PM.
 
Old 09-12-2006, 02:19 PM   #8
RetiredInMaine
Member
 
Registered: Jun 2006
Location: Maine
Distribution: ubuntu
Posts: 33

Original Poster
Rep: Reputation: 15
Smile Thank you

I did some checking and OOo mail merge will connect with MySQL but there is no indication that ir can connect with postgresSQL. Combined with the ability to convert back to MS Access in the future makes it a simple choice. I am going to install MySQL and go from there. Thanks again to all of you for taking the time to help me with my problem.

I'll post the results after I get it working.
 
Old 09-26-2006, 09:48 AM   #9
RetiredInMaine
Member
 
Registered: Jun 2006
Location: Maine
Distribution: ubuntu
Posts: 33

Original Poster
Rep: Reputation: 15
OK, My problem has been solved thank you all for your help in this and other threads.
 
  


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
LXer: OOo Off the Wall: The Elephant in the Living Room -- OOo and MS Office LXer Syndicated Linux News 0 02-06-2006 01:01 PM
Scripting framework error running OOO base (v. 2.0) macros in SUSE v.10 DeekBeek Linux - Software 2 01-14-2006 02:52 PM
Help! Java Database programming using OOo Base mmarkvillanueva Programming 6 10-29-2005 02:20 AM
OOo PhuckFonix Mandriva 2 07-12-2004 03:54 AM
OOo PhuckFonix Linux - Software 1 07-11-2004 11:18 PM


All times are GMT -5. The time now is 10:40 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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration