Will Access accept data formatted for MySQL databases?

  • Thread starter Thread starter Guest
  • Start date Start date
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"
 
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
 
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.
 
You must log in or register to reply here.

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

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Problem with Import or Linked Tables with MySql 1
Linking MYSQL 1
Importing Oracle/MYSQL data into Access?! 1
Impoting data from a MySql database 4
Access for MySQL data reports only 5
How to link Access to MySQL 1
Information about character lost from MySQL to Access 4

Back
Top