How do i open a .sql file in access?

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

 

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.

 

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.

 

or googleing "mysql to access converter" comes up with some viable options

 

i'll try the xampp thing, cheers skellig

 

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.

 

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.

 

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...

 

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.

 

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.

 

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