SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Dec 1999
    Location
    Munster
    Posts
    41
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi i was wondering how i can export my data from a access database to a mysql database. It has about 16000 records that i need to export. Any help that i could get on this would be great. Thank you

    Dave

  2. #2
    SitePoint Enthusiast
    Join Date
    Jul 2000
    Posts
    35
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Do the Save As/Export thing in Access. Save your table as a delimited text file (I use the pipe "|" character so I don't get into trouble with commas, semicolons, etc.). Then, go to this page in the MySQL manual for instructions on how to import it:
    http://www.mysql.com/documentation/m...on=mysqlimport

    I use phpMyAdmin from phpwizard.net instead.

    If you have the Windows MySQL ODBC drivers installed you can also export Access databases to your server running MySQL. Read this:
    http://www.iserver.com/support/addon.../msaccess.html


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
  •