Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2009
    Posts
    12

    Unanswered: easiest way to convert Access DB into SQL?

    I want to try my Access DB into Joomla but the latter is only compatible with SQL, what's the easiest + quickest + idiot-proof way to convert Access DB into SQL?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    well seeing as Access is a variant of SQL I'm confused, unless you mean the Joomala only works with specific SQL engines

    there use to be a tool called dbtools which would do the job pretty painlessly

    failing that you could explore the MySQL Migration tool

    failing that you could export the data using CSV files or simialr, and then load the data within MySQL
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2009
    Posts
    21
    You could also load it as SQL.
    Try to find if access exports sql

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by sakis View Post
    You could also load it as SQL.
    Try to find if access exports sql
    maybe ~you~ should see if Access can export SQL, before you suggest it

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Dec 2009
    Posts
    12
    Hey, if anyone is interested I managed with a very idiot-proof (the idiot here being me) software called bullzip, pretty quick too

Posting Permissions

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