[NMLUG] Access to MYSQL

[alrice at swcp.com (Alex Rice)]

On Feb 5, 2004, at 1:23 PM, Joseph Green wrote:

> I am just looking to get the data out of one table.
> I have a table called labs with  9 fields.
> Can you tell me the details.

I've done something similar to this before:

Install the MyODBC driver for Windows.
Create a new DSN in MS Windows pointing to your MySQL server
Create table on MySQL Server
Launch MS Access
Copy-paste your data from the Access table to the MySQL table all from 
within Access.

BTW using MyODBC drivers is an easy way to make a GUI for a MySQL 
database, extremely quickly, using the GUI forms and record-detail 
wizards in MS Access.

Alex