#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Posts
    2
    Rep Power
    0
    I have an Access database of around 11,000 products that I am trying to import into MySQL and use PHP3 for search and dynamic display on webpages. Does anyone have any recommendations on how to achieve this somewhat gracefully? The server is Apache and PHP3 and MySQL are already intalled.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 1999
    Location
    Netherlands
    Posts
    77
    Rep Power
    16
    Hi,

    The easiest way around is to download MyODBC from http://www.mysql.net/download_myodbc.html and install it. Configure it to match your server and database, and you can access your MySQL database from Access.

    Hope this helps you,
    Peter

Similar Threads

  1. PHP & MS Access
    By Tekime in forum PHP Development
    Replies: 4
    Last Post: November 5th, 2003, 05:48 PM
  2. access denied error message
    By -Dman100- in forum Windows Help
    Replies: 1
    Last Post: October 27th, 2003, 05:48 PM
  3. Linking Mysql and Access forms and reports
    By Prathmesh in forum MySQL Help
    Replies: 0
    Last Post: October 23rd, 2003, 12:15 AM
  4. Replies: 0
    Last Post: June 1st, 2003, 06:48 PM
  5. Accessing DB through MS Access?
    By Joen in forum MySQL Help
    Replies: 2
    Last Post: April 24th, 2002, 05:24 PM

IMN logo majestic logo threadwatch logo seochat tools logo