openSUSE Forums > Applications » Opening a MS Access (.mdb) file in linux

Go Back   openSUSE Forums > Applications
Forums FAQ Members List Search Today's Posts Mark Forums Read

Applications Questions about desktops (KDE, Gnome, XFCE, etc.), software applications (configuration, usage, bugs, documentation)

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 03-Jul-2009, 09:38
suse_tpx60s's Avatar
Parent Penguin
 
Join Date: May 2009
Location: EU
Posts: 602
suse_tpx60s hasn't been rated much yet
Default Opening a MS Access (.mdb) file in linux

I have a MS Access database file I need to open - I'm guessing with OpenOffice Base. Googling tells me I should open it by connecting to it via ODBC but the Linux version of OpenOffice does not seem to have an ODBC driver. Has anyone managed to get OO to open a access file under linux?

I could boot over to XP and do it that way but would like to find a solution in Linux.
__________________
IBM Thinkpad X60s | Intel L2400 | Intel 945GM | 3GB | openSuSE 11.2 | KDE4.4RC3
ASUS
M3N78 | AMD 64x2 5400+ | nvidia 8200+ | 2GB | openSUSE 11.2 | KDE4.3.5
Reply With Quote
  #2 (permalink)  
Old 03-Jul-2009, 09:44
caf4926's Avatar
Administrator
 
Join Date: Jun 2008
Location: The English Lake District. UK - GMT/BST
Posts: 16,370
caf4926 has a reputation beyond reputecaf4926 has a reputation beyond reputecaf4926 has a reputation beyond reputecaf4926 has a reputation beyond reputecaf4926 has a reputation beyond reputecaf4926 has a reputation beyond reputecaf4926 has a reputation beyond reputecaf4926 has a reputation beyond reputecaf4926 has a reputation beyond reputecaf4926 has a reputation beyond reputecaf4926 has a reputation beyond repute
Send a message via MSN to caf4926
Default Re: Opening a MS Access (.mdb) file in linux

Looks like best option would be using windows, you could install XP in Virtual Box.
I did find this also:
dba: Linux MDB driver - alpha version
__________________
Box: openSUSE 11.2 | (KDE4.3.5) | M2N4-SLI | AMD 64 X2 5200+ | nVidia 8500GT | 4GB RAM
Lap: openSUSE 11.2 | Celeron 550 | KDE 4.4 RC3 "release 218" | Intel 965 GM | Lenovo R61e | 3GB RAM
Reply With Quote
  #3 (permalink)  
Old 03-Jul-2009, 09:45
deltaflyer44's Avatar
Shaman Penguin
 
Join Date: Jan 2008
Location: U.K East Anglia
Posts: 2,603
deltaflyer44 hasn't been rated much yet
Default Re: Opening a MS Access (.mdb) file in linux

OOo will not open mdb files due to using MSjet,which is MS proprietary software. Try Kexi, it's a koffice app,that's what i use,providing it's not office 2007, kexi will open it. or you could use mdbviewer & export the files as csv & import them

Andy
__________________
To be is to do = Immanuel Kant
To do is to be = Descartes.
Do be do be do = Frank Sinatra

SuSE user since 7.0,Linux user since 1994
Reply With Quote
  #4 (permalink)  
Old 03-Jul-2009, 09:52
caf4926's Avatar
Administrator
 
Join Date: Jun 2008
Location: The English Lake District. UK - GMT/BST
Posts: 16,370
caf4926 has a reputation beyond reputecaf4926 has a reputation beyond reputecaf4926 has a reputation beyond reputecaf4926 has a reputation beyond reputecaf4926 has a reputation beyond reputecaf4926 has a reputation beyond reputecaf4926 has a reputation beyond reputecaf4926 has a reputation beyond reputecaf4926 has a reputation beyond reputecaf4926 has a reputation beyond reputecaf4926 has a reputation beyond repute
Send a message via MSN to caf4926
Default Re: Opening a MS Access (.mdb) file in linux

Quote:
Originally Posted by deltaflyer44 View Post
OOo will not open mdb files due to using MSjet,which is MS proprietary software. Try Kexi, it's a koffice app,that's what i use,providing it's not office 2007, kexi will open it. or you could use mdbviewer & export the files as csv & import them

Andy
Sounds much better advice than mine
__________________
Box: openSUSE 11.2 | (KDE4.3.5) | M2N4-SLI | AMD 64 X2 5200+ | nVidia 8500GT | 4GB RAM
Lap: openSUSE 11.2 | Celeron 550 | KDE 4.4 RC3 "release 218" | Intel 965 GM | Lenovo R61e | 3GB RAM
Reply With Quote
  #5 (permalink)  
Old 03-Jul-2009, 10:24
suse_tpx60s's Avatar
Parent Penguin
 
Join Date: May 2009
Location: EU
Posts: 602
suse_tpx60s hasn't been rated much yet
Default Re: Opening a MS Access (.mdb) file in linux

Thanks. I don't really want to install Kexi just to read this DB file once so will probably use boot to XP and use mdbviewer.
__________________
IBM Thinkpad X60s | Intel L2400 | Intel 945GM | 3GB | openSuSE 11.2 | KDE4.4RC3
ASUS
M3N78 | AMD 64x2 5400+ | nvidia 8200+ | 2GB | openSUSE 11.2 | KDE4.3.5
Reply With Quote
  #6 (permalink)  
Old 27-Jul-2009, 02:58
Puzzled Penguin
 
Join Date: Jul 2009
Posts: 1
Yanko_1876 hasn't been rated much yet
Default Re: Opening a MS Access (.mdb) file in linux

Quote:
Originally Posted by suse_tpx60s View Post
I have a MS Access database file I need to open - I'm guessing with OpenOffice Base. Googling tells me I should open it by connecting to it via ODBC but the Linux version of OpenOffice does not seem to have an ODBC driver. Has anyone managed to get OO to open a access file under linux?

I could boot over to XP and do it that way but would like to find a solution in Linux.
In Windows XP Oo go to Data Base/ Conect to ... and ot the top you have Microsoft Access and Browse the file.
ODBC is no good.
If u have 2007 madb u can choise on the last u have access 2007.
Reply With Quote
Reply

Bookmarks


Thread Tools
Display Modes

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 On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




 

Search Engine Friendly URLs by vBSEO 3.3.2