Importing or Connecting a SQL database to Access 2010

[markcrobinson]

My Shopping cart is in a MySQL database on the web. I would like to bring the database into Access 2010 for Datamining.
Problem is that some of the MySQL fields are 650 characters long and importing by downloading in Excel of XML format truncates these fields.
Is there a way to import a MySQL database into Access?

Im on Windows 7

 

[oharab]

You need some sort of MySQL ODBC connector such as this one. You should then be able to access your database using linked tables, assuming your MySQL database isn't behind a firewall.

hth

Ben

----------------------------------------------
Ben O'Hara

We could be confused in exactly the same way, but confusion might be like Nulls, and not comparable.