Results 1 to 6 of 6

Thread: Opening a MS Access (.mdb) file in linux

  1. #1
    Join Date
    May 2009
    Location
    US
    Posts
    867

    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 Tumbleweed
    Dell XPS 13 9360 | openSUSE Leap 42.3

  2. #2
    Join Date
    Jun 2008
    Location
    The English Lake District. UK - GMT/BST
    Posts
    36,729
    Blog Entries
    20

    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
    Leap 15.1_KDE
    My Articles Was I any help? If yes: Click the star below

  3. #3
    Join Date
    Jan 2008
    Location
    U.K East Anglia
    Posts
    2,581

    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

  4. #4
    Join Date
    Jun 2008
    Location
    The English Lake District. UK - GMT/BST
    Posts
    36,729
    Blog Entries
    20

    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
    Leap 15.1_KDE
    My Articles Was I any help? If yes: Click the star below

  5. #5
    Join Date
    May 2009
    Location
    US
    Posts
    867

    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 Tumbleweed
    Dell XPS 13 9360 | openSUSE Leap 42.3

  6. #6
    Yanko_1876 NNTP User

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •