LinuxQuestions.org
Review your favorite Linux distribution.
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 10-18-2008, 04:43 AM   #1
checkmate3001
Member
 
Registered: Sep 2007
Location: Folsom, California
Distribution: Debian 4.0 (Etch), Debian 5.0 (Lenny), Ubuntu 8.04
Posts: 301

Rep: Reputation: 32
Linux Open Office and MS Access .mdb files


I'm on the verge of a mental melt-down.

I want to open a MS Access (.mdb) file in Open Office under linux. I've found several web sites talking about using an ODBC and blah blah blah... none of it I understand.

I guess all I want to know is this: Can a person open, obtain information from, export, etc information from a MS Access (Office 97) .mdb file?

I want to get the information off in whatever way it the fastest/easiest so I can recreate the database with minimal effort in mysql.

Everytime I open it in Open Office and click on Tables Open Office crashes (I haven't seen a crash in linux in forever - it has to be MS's fault).

Am I doing something wrong, or am I expecting Open Office to do something that it simply cannot?

P.S. I've tried mdbtools also - it crashes as well with the error: "Segmentation fault".

Last edited by checkmate3001; 10-18-2008 at 04:45 AM. Reason: added info about mdbtools
 
Old 10-18-2008, 05:57 AM   #2
JSkywalker
Member
 
Registered: Aug 2007
Distribution: openSUSE 12.1
Posts: 96

Rep: Reputation: 24
this is some info i found at the openoffice.org website...

http://www.openoffice.org/FAQs/ms-access.pdf

but i think you need a windows computer to do that...
 
Old 10-18-2008, 07:15 AM   #3
catweasel28
Member
 
Registered: Mar 2007
Location: United Kingdom
Distribution: Mint, OpenSUSE,Dream
Posts: 68

Rep: Reputation: 17
.mdb into OOBase

You'll run into problems if your .mdb file contains forms and reports. These use libraries that are not supported by OOB.

These links might prove helpful.

http://www.oooforum.org/forum/viewtopic.phtml?t=75155

http://www.oooforum.org/forum/viewtopic.phtml?t=41006

http://www.oooforum.org/forum/viewtopic.phtml?t=39816

Best of luck!
 
Old 10-18-2008, 04:27 PM   #4
checkmate3001
Member
 
Registered: Sep 2007
Location: Folsom, California
Distribution: Debian 4.0 (Etch), Debian 5.0 (Lenny), Ubuntu 8.04
Posts: 301

Original Poster
Rep: Reputation: 32
Thank you two for your help. However, I have come to the conclusion that the only (and most reliable) way to recreate the database for use on linux with mysql is to either export everything to text (.csv) and import that to mysql or just rewrite everything from scratch.
 
Old 10-18-2008, 07:07 PM   #5
XavierP
Moderator
 
Registered: Nov 2002
Location: Kent, England
Distribution: Lubuntu
Posts: 19,176
Blog Entries: 4

Rep: Reputation: 429Reputation: 429Reputation: 429Reputation: 429Reputation: 429
http://sourceforge.net/projects/mdbtools
http://dba.openoffice.org/drivers/mdb/index.html
http://solyaris.wordpress.com/2007/0...iles-on-linux/

These are pages that will be of help to you
 
  


Reply

Tags
access, microsoft, office, open


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
Samba 3, MS Access mdb files failures Normanjr Linux - Server 1 03-27-2008 12:38 AM
Open Office 2.0.1 Base Import secured MDB k.king Linux - Software 0 01-19-2006 02:52 PM
Using open office from Linux on Windows partition files munichtexan Linux - Software 1 12-07-2005 11:27 AM
NFS and MS Access MDB Files ja_nch Linux - Networking 1 09-20-2003 01:53 PM
how to access microsoft mdb in redhat linux 8 kjsubbu Linux - Software 8 06-02-2003 04:26 PM


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

Main Menu
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