How do i open a .sql file in access?

Discussion in 'MySQL' started by moneyballs2, Dec 2, 2006.

0
  1. #1
    Hello

    i have seen many converters on the internet to convert mysql databases to work in access, but you have to connect to the server. i don't have a server to connect to anymore, and therefore no database to connect to

    Is there a program that i can use to convert my .sql file which i have on my computer so that i can open it in access.

    Thanks
     
    moneyballs2, Dec 2, 2006 IP
  2. Pat Gael

    Pat Gael Banned

    Messages:
    1,331
    Likes Received:
    68
    Best Answers:
    0
    Trophy Points:
    0
    #2
    You can always install a server on your PC to do such task.

    Try www.apachefriends.org and you will be able to access locally all the functionality that you had in your old server.
     
    Pat Gael, Dec 2, 2006 IP
  3. Skellig

    Skellig Active Member

    Messages:
    205
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    58
    #3
    simplest way is defenitely to install xampp, then log into localhost, go to phpmyadmin and import the script with phpmyadmin.

    If you need to get it into an access db then you best bet is once xampp is installed setup an odbc connection to it, then open the connection from within access and voila you can do what you want with it.
     
    Skellig, Dec 2, 2006 IP
  4. krakjoe

    krakjoe Well-Known Member

    Messages:
    1,795
    Likes Received:
    141
    Best Answers:
    0
    Trophy Points:
    135
    #4
    or googleing "mysql to access converter" comes up with some viable options
     
    krakjoe, Dec 2, 2006 IP
  5. moneyballs2

    moneyballs2 Well-Known Member

    Messages:
    452
    Likes Received:
    27
    Best Answers:
    0
    Trophy Points:
    140
    #5
    i'll try the xampp thing, cheers skellig
     
    moneyballs2, Dec 2, 2006 IP
  6. falcondriver

    falcondriver Well-Known Member

    Messages:
    963
    Likes Received:
    47
    Best Answers:
    0
    Trophy Points:
    145
    #6
    whats in the sql file? is it just a single query or a whole data set with commands to create and populate a new database?

    you open the .sql with a text-ed, ctrl+c, go to access, create a blank db, go to "execute sql" (is there something like that? used '97 many years ago) and ctrl+v your sql in here.
     
    falcondriver, Dec 2, 2006 IP
  7. poseidon

    poseidon Banned

    Messages:
    4,356
    Likes Received:
    246
    Best Answers:
    0
    Trophy Points:
    0
    #7
    I am having same problem guys, I have a .sql dump file of 100 Mb size and I am looking to to open in Access.
     
    poseidon, Dec 4, 2006 IP
  8. moneyballs2

    moneyballs2 Well-Known Member

    Messages:
    452
    Likes Received:
    27
    Best Answers:
    0
    Trophy Points:
    140
    #8

    sorry to bring back an old topic...

    it's a whole set of commands to create a database with all the info. (it was a back-up from my iPanel database)

    I've tried the access thing, but it has too many characters...
     
    moneyballs2, Dec 9, 2006 IP
  9. falcondriver

    falcondriver Well-Known Member

    Messages:
    963
    Likes Received:
    47
    Best Answers:
    0
    Trophy Points:
    145
    #9
    dont know your skills or what software you have, but in windows 2k you can set up an odbc connection to your access file and then write some small vb or asp script to read this .sql line by line into your db.
    there is probably also some software who does the same, but i dont know any of them. maybe you have more luck if you can switch to mysql or any other "serious" database.
     
    falcondriver, Dec 9, 2006 IP
  10. Shahnawaz

    Shahnawaz Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #10
    in ur pc u can create an server by wamp. and it is much easy. then u 1st import it in access version with phpmyadmin and after that import it to ur desired location.
     
    Shahnawaz, Dec 21, 2006 IP
  11. surfnearnzone

    surfnearnzone Well-Known Member

    Messages:
    1,492
    Likes Received:
    62
    Best Answers:
    0
    Trophy Points:
    165
    #11
    I work in asp and access. i think this should work. Just copy the sql query, open a new sql query in access and post the above data. Save it and run it. I think this should help.

    Send me some sample data. I'll try it myself and update you :)

    It can't get any easier :D


     
    surfnearnzone, Dec 27, 2006 IP