Results 1 to 6 of 6

Thread: How to open up MS Access Db from Linux

  1. #1
    Join Date
    Dec 2008
    Location
    Anchorage, Alaska
    Posts
    19

    Default How to open up MS Access Db from Linux

    Is there a program that can open up a Microsoft Access database file on Linux?
    Joshua Gompert

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

    Default Re: How to open up MS Access Db from Linux

    I'm not sure there is. You need to install office in Linux. You can do this with Crossover, I'm not sure about Wine.

    But looks good; WineHQ - Microsoft Office (installer only)
    Leap 15.1_KDE
    My Articles Was I any help? If yes: Click the star below

  3. #3
    Join Date
    Dec 2008
    Location
    Sydney, Australia
    Posts
    1,020

    Default Re: How to open up MS Access Db from Linux

    You could try Wine but I wouldn't for any of the MS Office stuff, especially not for Access. That's what Virtualbox is for: no fiddling, no worries.
    Günter

    Desk: Leap 42.2, KDE 5, Intel i3, 8Gb, Kingston 64Gb SSD, 2 SATA.
    Lap: Thinkpad T430, Tumbleweed, Intel i5, 8Gb, SSD.

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

    Default Re: How to open up MS Access Db from Linux

    Quote Originally Posted by gminnerup View Post
    You could try Wine but I wouldn't for any of the MS Office stuff, especially not for Access. That's what Virtualbox is for: no fiddling, no worries.
    Agree - Virtual Box is really excellent.
    Leap 15.1_KDE
    My Articles Was I any help? If yes: Click the star below

  5. #5
    Join Date
    Sep 2008
    Location
    Dubai
    Posts
    1,770

    Default Re: How to open up MS Access Db from Linux

    You may convert the MS Access database files to one of the better databases supported under Linux - Postgres, MySQL etc.
    Try the kexi project.
    Kexi Project - "Microsoft Access for Linux" - Home
    openSUSE 12.3 (x86_64) with Kernel 3.7.10-1.16-desktop and KDE 4.11.2 on MacBook Pro
    Latest MS Windows version used: Win95

  6. #6
    Join Date
    Jun 2008
    Location
    West Yorkshire, UK
    Posts
    3,450

    Default Re: How to open up MS Access Db from Linux

    If the relationships between your Access tables are simple, you may be able to convert them to csv, e.g. via Excel, and import them into mysql.

    The mysql manual gives the specification for importing Windows/DOS csv files into mysql and it is worth preparing them in this way as, if you get them correct, the import is almost instantaneous.

    If the relationships are complicated, it may or may not be advantageous to convert them to SQL within Access. (I don't know if this conversion would preserve the relationships in a way which would then be preserved in mysql).

    BTW Access can be set up to access mysql tables.
    Last edited by john_hudson; 13-Dec-2009 at 13:39. Reason: Additional comment

Posting Permissions

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