At 2:07 +0100 8/5/02, Donna Robinson wrote:
>FilterFodder: sql, query
>the whole world out there is telling me how to connect to MySql from Access,
>but I need to know how to do it the _other_ way round.
>I have to update a MySql database every few months from an Access dbase, and I
>just want to query access and get the data i need. How can I do this? Do I
>really have to jump thru hoops and install MyODBC etc., etc? I do NOT need
>to export data back to access, just schlurp it in from there.
No, you need to export it *from* Access to the MySQL server, which is
a server and not a client that can connect to Access.