Results 1 to 5 of 5

Thread: how to convert Access MDB file into an ASCII file ?

  1. #1

    Default how to convert Access MDB file into an ASCII file ?

    Hi,

    I have opensuse 11 installed. I would like to know if from this OS, there's a way to export a Table from Microsoft Access MDB file, into CSV or ASCII text format? But I need it to run from the shell, because I would like to put this command into a script to run automatically.

    For example, something like this:

    mdbtools <filename.mdb> <table name> <output_filename.txt>

  2. #2
    Join Date
    Oct 2008
    Location
    North Wales, UK
    Posts
    1,114

    Default Re: how to convert Access MDB file into an ASCII file ?

    Trouble with access is that it uses microsoft's own formatting and not that many average people use access compared to word or excel. This means that most linux or even non M$ Office windows programs will read access files.
    The best way to get it converted is directly in windows from a running version of access.
    Another way would be to use an odbc connection to the database file and use sql commands to export the tables. Trouble is, I don't think you will find a linux odbc connector for access.

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

    Default Re: how to convert Access MDB file into an ASCII file ?

    If the file is not too complicated, you could import the fields into an Excel file, save it, open it in OpenOffice and export as CSV.

    (That would give you the Linux line endings rather than the Windows ones).

  4. #4
    MadKow NNTP User

    Default Re: how to convert Access MDB file into an ASCII file ?

    When you have mdbtools installed, you can use mdb-export to export a table from an mdb file to csv

    mdb-export file.mdb tablename > file.csv

  5. #5

    Default Re: how to convert Access MDB file into an ASCII file ?

    You can use Pentaho Data Integration (aka Kettle) for that.

    You create a transformation in a GUI (called spoon). You can run the transformation from within the GUI or through the commandline using pan.

    If you're going to do "stuff" with that data you might want to check it out - it's a very powerful open source suite of tools.

    Cheers

Posting Permissions

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