8 messages in com.mysql.lists.mysqlRe: MySql <- Access
FromSent OnAttachments
Donna Robinson04 Aug 2002 18:07 
Paul DuBois04 Aug 2002 18:40 
[XG]Boomer04 Aug 2002 22:40 
Terence04 Aug 2002 22:54 
Donna Robinson05 Aug 2002 02:26 
[XG]Boomer05 Aug 2002 02:32 
Tod Harter05 Aug 2002 14:45 
Mauricio Sthandier R.13 Aug 2002 07:19 
Subject:Re: MySql <- Access
From:Paul DuBois (pa@snake.net)
Date:08/04/2002 06:40:17 PM
List:com.mysql.lists.mysql

At 2:07 +0100 8/5/02, Donna Robinson wrote:

FilterFodder: sql, query

Hi, 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.

Donna