Link to MySQL (surely obvious but...)

[Kartos]

I am sorry if this question is too basic but I cannot find an answer in the
older posts.

I need to link MsAcces to MySQL tables. In Access I choose "File > Get
External Data > Link Tables". Then in "Files of type" I select "ODBC
Databases()".

Here I have a problem:
Which tab I must select: "File data source" or "System data source"?
Whichever I selecet and click New data source, I get a list of available
drivers. Unfortunately none of their names is similar to MySQL.

Please help.
I guess I need to install a driver, but what it is and where to find it - I
have no idea

TIA
Kartos

 

[GVaught]

A little Internet search goes along way. Using this phrase: Linking Access
to MYSQL databases in the address window of my browser.

http://www.washington.edu/computing/web/publishing/mysql-access.html

 

[Kartos]

That's it! What I was missing was the ODBC driver. I thought Windows XP
should include such things by default (like e.g. it has drivers for
different printers).
Anyway my problem is solved. Thanks a lot!
Kartos