Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: Coverting Access data to SQL query

    Hi There
    im try to find out if there is a way, of converting an Access db to a .SQL extension file.

    I have some web space with a MySQL db attached, and i use phpMyAdmin to update, drop etc the database (i have no direct contact with it). I want all the data in my Access db onto my MySQL db without having to enter each row in. phpMyAdmin can use .SQL files to populate db, but i need to export the Access data into an SQL file format.


  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    I'd suggest that you use an ETL tool. That makes this process much easier, although it assumes that you can get progmatic access to both of the databases.

    If you can get ODBC access to both databases (MS-Access is a "gimme", the MySQL database could be easy or a challenge), then you have lots of choices at very low cost.

    You can generate an SQL script from an Access database progmatcially, but it is often quite a bit of work. I'd strongly suggest that you investigate other choices first.


Posting Permissions

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