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

Read an .mdb file

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


Joined: 24 Feb 2006
Posts: 7
Location: California

PostPosted: Sun Oct 22, 2006 7:33 am    Post subject: Read an .mdb file Reply with quote

I am not technically smart. That said,

Is there any way to open an .mdb file in OO? I was told so, but can't find instructions.

Could someone please help me and give me instructions to use?

Thank you.
_________________
Benedict1
Back to top
View user's profile Send private message
Robert Tucker
Moderator
Moderator


Joined: 16 Aug 2004
Posts: 3407
Location: Manchester UK

PostPosted: Sun Oct 22, 2006 7:40 am    Post subject: Reply with quote

www.oooforum.org/forum/viewtopic.phtml?t=41006
www.oooforum.org/forum/viewtopic.phtml?t=39816
Back to top
View user's profile Send private message
benedict1
General User
General User


Joined: 24 Feb 2006
Posts: 7
Location: California

PostPosted: Sun Oct 22, 2006 1:58 pm    Post subject: Reply with quote

I must be totally stupid. I can't make this work with v 2.0 Nothing looks the same as the links you gave me. For example, I cannot find the popup so I can check "Microsofte Access"

I have a database of Street Names for a certain county in the form *.mdb I want to open it up so I can find a street name.

Can somebody take me through the steps, please?
_________________
Benedict1
Back to top
View user's profile Send private message
Robert Tucker
Moderator
Moderator


Joined: 16 Aug 2004
Posts: 3407
Location: Manchester UK

PostPosted: Mon Oct 23, 2006 12:34 am    Post subject: Reply with quote

benedict1 wrote:
For example, I cannot find the popup so I can check "Microsofte Access"


Are you using Windows or Linux?
Back to top
View user's profile Send private message
benedict1
General User
General User


Joined: 24 Feb 2006
Posts: 7
Location: California

PostPosted: Mon Oct 23, 2006 4:20 am    Post subject: Reply with quote

Windows XP SP2 with all patches in place.

The screens I get in OO 2. don't match the screens in the nice tutorial at

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

That is all done in version 1.1.
_________________
Benedict1
Back to top
View user's profile Send private message
Robert McLean
General User
General User


Joined: 16 Oct 2006
Posts: 5

PostPosted: Mon Oct 23, 2006 4:38 am    Post subject: same problem using OO0 2.0 on Linux Reply with quote

I have the same problem, but on Linux. see thread
http://www.oooforum.org/forum/viewtopic.phtml?t=45723

So you are not alone. I wish I had an answer for you.
Back to top
View user's profile Send private message
Robert Tucker
Moderator
Moderator


Joined: 16 Aug 2004
Posts: 3407
Location: Manchester UK

PostPosted: Mon Oct 23, 2006 5:11 am    Post subject: Reply with quote

There are Linux instructions for OOo1.1 at:

http://dba.openoffice.org/drivers/mdb/index.html

but I didn't get them to work (with OOo2.0.x).

I have however succeeded in extracting tables from .mdb files using "MDB Tools" on Linux.

http://mdbtools.sourceforge.net/
http://sourceforge.net/projects/mdbtools
Back to top
View user's profile Send private message
Robert McLean
General User
General User


Joined: 16 Oct 2006
Posts: 5

PostPosted: Mon Oct 23, 2006 8:49 am    Post subject: Reply with quote

Quote:
I have however succeeded in extracting tables from .mdb files using "MDB Tools" on Linux.


Thanks, I will give those a try.
Back to top
View user's profile Send private message
freemc
General User
General User


Joined: 27 Oct 2006
Posts: 20
Location: Belgium

PostPosted: Fri Oct 27, 2006 12:59 pm    Post subject: Reply with quote

After you open Base, in the Database Wizard you can select "Connect to existing database". Then select "Microsoft Acces". Click next and select your *.mdb file, then finish. Base will make a lot of tables, and somewhere between them you will find your original Acces tables. I don't know if it will also transfer forms and stuff as I didn't have those in my Database. It will save a very small .odb file, but you will need both your .mdb and the .odb files to acces your data.

also check this (sticky): http://www.oooforum.org/forum/viewtopic.phtml?t=44517
_________________
Can't win if you don't play
Back to top
View user's profile Send private message Visit poster's website 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