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"
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Import or Linked Tables with MySql 1
Linking MYSQL 1
Access with MySQL + SQL Server 2
Impoting data from a MySql database 4
Importing Oracle/MYSQL data into Access?! 1
How to link Access to MySQL 1
Access for MySQL data reports only 5
MYSQL 1

Top