| View previous topic :: View next topic |
| Author |
Message |
benedict1
General User
Joined: 24 Feb 2006
Posts: 7
Location: California
|
 Posted: Sun Oct 22, 2006 7:33 am Post subject: Read an .mdb file |
 |
|
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 |
|
 |
Robert Tucker
Moderator
Joined: 16 Aug 2004
Posts: 3367
Location: Manchester UK
|
|
| Back to top |
|
|
benedict1
General User
Joined: 24 Feb 2006
Posts: 7
Location: California
|
| Posted: Sun Oct 22, 2006 1:58 pm Post subject: |
|
|
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 |
|
|
Robert Tucker
Moderator
Joined: 16 Aug 2004
Posts: 3367
Location: Manchester UK
|
| Posted: Mon Oct 23, 2006 12:34 am Post subject: |
|
|
| benedict1 wrote: | For example, I cannot find the popup so I can check "Microsofte Access"
|
Are you using Windows or Linux? |
|
| Back to top |
|
|
benedict1
General User
Joined: 24 Feb 2006
Posts: 7
Location: California
|
| Posted: Mon Oct 23, 2006 4:20 am Post subject: |
|
|
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 |
|
|
Robert McLean
General User
Joined: 16 Oct 2006
Posts: 5
|
|
| Back to top |
|
|
Robert Tucker
Moderator
Joined: 16 Aug 2004
Posts: 3367
Location: Manchester UK
|
|
| Back to top |
|
|
Robert McLean
General User
Joined: 16 Oct 2006
Posts: 5
|
| Posted: Mon Oct 23, 2006 8:49 am Post subject: |
|
|
| 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 |
|
|
freemc
General User
Joined: 27 Oct 2006
Posts: 20
Location: Belgium
|
| Posted: Fri Oct 27, 2006 12:59 pm Post subject: |
|
|
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 |
|
|
|
