SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    AdSpeed.com Son Nguyen's Avatar
    Join Date
    Aug 2000
    Location
    Silicon Valley
    Posts
    2,241
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    This might be an old topic, but now I gotta deal with it.
    So how would you go about converting a MS Access file to MySQL. Currently I'm thinking of converting to CSV and then to MySql. Don't know if it seems right?

    Thanks
    - Son Nguyen
    AdSpeed.com - Ad Serving and Ad Management Made Easy

  2. #2
    SitePoint Evangelist CyberFuture's Avatar
    Join Date
    May 2001
    Location
    San Diego, CA
    Posts
    434
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Just go to www.mysql.com and download the myODBC driver. This will allow you to upload your tables from Access directly to MySQL. MyODBC will also let you edit and query the mysql tables in Access. The only thing to remember is that none of your table and field names can have any spaces in mySQL.


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
  •