Will Access accept data formatted for MySQL databases?

J

John Nurick

If you mean "Can Access execute a SQL script intended for MySQL?", the
answer is no. Otherwise, what do you mean?

On Wed, 22 Dec 2004 07:57:02 -0800, "jimtotem"
 
J

jimtotem

Thank you John,for answering my post:

In Access and Excel, we store data in tables or spreadsheets. Can that type
of data, from a MySQL database be imported (converted or translated) into an
Access database table?

Jim
 
J

John Nurick

Yes, Jim. You need to use an ODBC driver for MySQL (it may already be
installed on your system, otherwise download it from the MySQL site;
Microsoft does not supply or provide support for it). The driver will
let you connect to the MySQL database and access the data in the MySQL
tables.

I've never worked with MySQL so don't know the details, but the usual
drill with ODBC is (once the driver is installed) to go to the Windows
Control Panel, open the Data Sources (ODBC) applet, and create a DSN for
the database.
 
Top