LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (http://www.linuxquestions.org/questions/linux-software-2/)
-   -   Linux Open Office and MS Access .mdb files (http://www.linuxquestions.org/questions/linux-software-2/linux-open-office-and-ms-access-mdb-files-677279/)

checkmate3001 10-18-2008 04:43 AM

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".

JSkywalker 10-18-2008 05:57 AM

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...

catweasel28 10-18-2008 07:15 AM

.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!

checkmate3001 10-18-2008 04:27 PM

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. :(

XavierP 10-18-2008 07:07 PM

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


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