Thread: how to write Microsoft Access MDB file to a text file?

  1. #1
    Registered User
    Join Date
    Jul 2009
    Posts
    17

    how to write Microsoft Access MDB file to a text file?

    I'm in the UNIX environment. I'd like to read a Microsoft Access MDB file, and convert the contents of that file into an ASCII text file. I want to write a C program to do this.

    Does anyone know if there's already source code out there that does this?
    Please advise. Thanks.

  2. #2
    Dr Dipshi++ mike_g's Avatar
    Join Date
    Oct 2006
    Location
    On me hyperplane
    Posts
    1,218
    MDBtools can convert an Access database to a set of CSVs, or MySQL code. Theres a bit of an explanation of how to use it here. Since its in the Ubuntu repository it should be FOSS too, dunno if its made in C though.

  3. #3
    Registered User
    Join Date
    Jul 2009
    Posts
    17
    I should explain my problem better by describing what I'm doing:

    My platform is on Solaris. I have already written C codes to
    interpret data AFTER they got extracted from Microsoft Access. The way
    it's done right now, is that the users have to go to a Windows PC, copy that MDB file onto the network drive on Solaris, open up MS Access, export each MDB file into a text file on the network drive on Solaris.

    Then, these users would run my C program to intepret all of that data (in ASCII text format). So I'd like to make it easier for the users when they export the MDB file.

    And the way to do it is to copy each MDB file to the network drive on Solaris, read the Access mdb file from a C program on Solaris and
    automatically output that MDB file into a text file, and then, this is tied into the second C program, which interprets that text file.

    So I'm interested how to write the C program to read the MDB file and writing its content into an ASCII text file.

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. C++ std routines
    By siavoshkc in forum C++ Programming
    Replies: 33
    Last Post: 07-28-2006, 12:13 AM
  2. Dikumud
    By maxorator in forum C++ Programming
    Replies: 1
    Last Post: 10-01-2005, 06:39 AM
  3. Unknown Memory Leak in Init() Function
    By CodeHacker in forum Windows Programming
    Replies: 3
    Last Post: 07-09-2004, 09:54 AM
  4. Function is called and I am trying to open a file
    By tommy69 in forum C Programming
    Replies: 88
    Last Post: 05-06-2004, 08:33 AM
  5. simulate Grep command in Unix using C
    By laxmi in forum C Programming
    Replies: 6
    Last Post: 05-10-2002, 04:10 PM