MySQL and Access

[JamieNZ]

Hi all...

I'm new to mySQL and SQL. I want to be able to get a recordset from a MySQL db and insert that recordset into an Access table on the click of a button in Access.

I can get the recordset from mySQL, not sure of the easiest or quickest way to get that recordset into a table in Access.

Can anyone help?

Thankyou

Jamie

 

[mjmartin]

Of course you will need to install the MyODBC drivers so that Access can play nicely with MySQL. These are available in the 'Downloads' section of http://www.mysql.com