Newbie ODBC question

[Stephen Glynn]

Can someone talk me through the process of making an access database --
let's say Northwind -- accessible to mySQL, which uses the MySQL ODBC
3.51 Driver DSN (which I've installed on my PC).

I go to Control Panel>Administrative Tools>DataSources

What do I do now? (Or where can I read up on it online)?

Steve

 

[jim lange]

Stephen,
forgive me if I misunderstand your question ( too much sun and fruity
drinks!). if you want to convert an access database to mySQL tables you can
use a converter like Access_to_mySQL from bullzip.com. this will suck all
your tables from Access and put them on a mySQL server for you. the ODBC
drivers are not necessary for this. you would only need the drivers if you
want to use Access as the front end to use the data on the mySQL server.

HTH,

jim

 

[Van T. Dinh]

I might have read your question incorrectly but if you have Access/JET
Tables and you want these Tables available in your MySQL Database then you
you use the Access ODBC driver to create a DSN, NOT the MySQL driver.

I don't know about MySQL so I cannot advise more and you will have to check
your MySQL documentation to see how to use Access (JET, actually) in MySQL
as there may be more than one way. Suggest you also check the Web sites
that specialise on MySQL.