Convert MySQL SQL dump to access format?

primesuspectprimesuspect Beepin n' BoopinDetroit, MI Icrontian
edited September 2006 in Internet & Media
I had a customer request a dump of raw SQL data from a mysql server into something access can import.

I looked for convertors, but I couldn't find one. Anybody ever do this before?

Comments

  • shwaipshwaip bluffin' with my muffin Icrontian
    edited September 2006
    can you copy/paste the mysqldump text into the sql view of an access query?
  • ShortyShorty Manchester, UK Icrontian
    edited September 2006
    Oooo that's a hella difficult one. Il see what I can find mate..
  • ShortyShorty Manchester, UK Icrontian
    edited September 2006
    Just as a question, is there any reason why they can't run a local MySQL instance and then use MySQL ODBC driver access..? :)
  • AranyicAranyic Casstown, OH Icrontian
    edited September 2006
    http://www.convert-in.com/acc2sql.htm

    will that program do what you want?
  • ShortyShorty Manchester, UK Icrontian
    edited September 2006
    That migrates to MySQL from Access, Prime looks like he is looking for the opposite :(
  • AranyicAranyic Casstown, OH Icrontian
    edited September 2006
    Totally read that wrong. My story is I was distracted by the bengals game and i'm sticking to it.
  • ShortyShorty Manchester, UK Icrontian
    edited September 2006
    ahahahaha I can't say I blame ya dude :D
  • KwitkoKwitko Sheriff of Banning (Retired) By the thing near the stuff Icrontian
    edited September 2006
    First link doing a "MySQL to Access" Google:
    http://www.convert-in.com/sql2acc.htm
  • ShortyShorty Manchester, UK Icrontian
    edited September 2006
    Well bloody hell .. KwitCo .. the next generation search engine guru :respect:
  • primesuspectprimesuspect Beepin n' Boopin Detroit, MI Icrontian
    edited September 2006
    Nice! That's perfect! Thanks for being my google!

    i swear i didn't see that link
Sign In or Register to comment.