Opening MYSQL DB in Access?

[twinkle]

Is there any way to do this? Not sure why I wanted to do this except to be able to manually extract some data from one of my website databases. All my websites run mysql, but I do not run mysql on my home machine. So I was going to see if I could just import the data file into access to look at the data.

Access would not read the file. Is this something that is not possible? Is there a program that will do a simple view of a mysql db file on my windows xp machine? I have tried some of those front-ends but they do way to much and want to read the running database. I just want to view the database as a static file.
_________________
I shine

[mikelbeck]

I'm pretty sure you can do this using the MySQL Connector/ODBC. There's some information about how to do it at this link: http://dev.mysql.com/doc/refman/5.0/en/msaccess-setup.html

[paul]

You can use phpmyadmin to look at your MySQL data online.


Paul
_________________
World Countries | Survival Skills

[twinkle]

Mikel,

Thanks for the tip. That sounds like what I was looking for, for sure.

Paul,

I the problem I had is I was trying to look into a backed up database that I had taken offline. So I was not at liberty to just pull it up in phpmyadmin. Thanks for the suggestion though!
_________________
I shine

[x-raysteve]

How did you export the file? Did you just export it into csv? You could have just opened it up in Excel if you did that.

[twinkle]

Actually I exported it as sql. I don't ususally save my backups as csv. Is there a way to read a sql file in excel?
_________________
I shine

[mikelbeck]

You can import it into Excel as a text file, but it's going to be way screwy when you do that.

If you use phpMyAdmin, I'm pretty sure there's an option to export it as either an SQL file or a CSV file.

[twinkle]