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

You can work directly with the MySQL tables in Access. You don't need to duplicate the data.

Go to File/Get External Data/ and link to the MySQL table. You can base your queries on the linked table or you can write an append or maketable query to copy the MySQL table to an Access table.

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