SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: Access to MySQL

  1. #1
    SitePoint Addict Phil-man's Avatar
    Join Date
    Nov 2000
    Posts
    291
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Access to MySQL

    Hi. I've spent a good amount of time searching the forums on this issue, but nothing seems to answer my specific question. I need to take a .mdb file created in Access and extract certain columns of data for import into MySQL. The process needs to be automated. For example, a nightly-run cron job would run a PHP script that somehow reads the .mdb file, takes what it needs, and imports that into MySQL. Or, the cron job could run some other process that accomplishes the same result. I'm most comfortable with PHP.

    * We do not have Access. Just .mdb files that were created in Access.
    * Getting a CSV export from Access is not an option in this case
    * We're using Linux

    Any ideas? Most of the things I found in other posts seemed to deal with desktop applications that could manually process the conversions, or they required that a CSV file be created from Access, or they required the Access software itself. None of that will work for us in this case.

    Thank you in advance!

  2. #2
    Non-Member DaveMichaels's Avatar
    Join Date
    Nov 2004
    Location
    US
    Posts
    535
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm not sure if that's possible without having Access installed. Maybe ODBC could connect.


Bookmarks

Posting Permissions

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