Results 1 to 3 of 3
  1. #1

    Access database accessed in php

    I need a way to access an access database in php on a Linux server or a way to convert the database to mysql (hopefully without having to retype the 500-1000+ rows in it).
    Video and Website Services
    Klingman Design, LLC

  2. #2
    Join Date
    Jul 2003
    To convert the database to MySQL, export it as CSV and then import it into MySQL using the LOAD DATA INFILE command.

    To access the database without converting it, you'll have to install an access ODBC driver on your linux server and use that to get to the mdb file.

    And finally, you can setup a script at the computer that has the access database, which you can query from your server to get information from the access database.
    In order to understand recursion, one must first understand recursion.
    If you feel like it, you can read my blog
    Signal > Noise

  3. #3
    Video and Website Services
    Klingman Design, LLC

Posting Permissions

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