MYSQL AND MS ACCESS Interoperability

transfering mysql data into MS Access

[dbarasuk]

Hi,
Is there any way of getting automatically (a kind of program or tool)mysql data into Microsoft Access?

Reason behind this: Suppose I work for a boss who requires the knowledge of MS Access, that I'm not quite familiar with MS Access but fluent in MYSQL. Is there any way to accomplish the tasks of that requirement using MYSQL and then getting data back to MS Access to satisfy such a boss?

Thanks

[Demaestro]

You can execute queries in MS Access almost the same as you would in MySql

How ever, if you want to do an exchange of data between the two I would use ODBC driver... it allows for easy exchange.

searching for: "ODBC Access to MySQL"

Gave me:

This allows applications such as Microsoft Access to exchange data with a database on the MySQL server.

[ucl.ac.uk...]

I didn't look through everything on that page so I can't say it is exactly what you need but I know that ODBC is the MS way of setting up database connections and passing info back and forth with. Just do some reading about the ODBC and you will should be good.

I am sure there are people are here that can help you get it set up if you run into problems.

Good luck and post back if you have more questions.

[dbarasuk]

hi DEMAESTRO,

I downloaded myODBC and things can be exchanged between the two database systems. However one MAJOR problem. Data that was once protected in MYSQL can be imported in PLAIN view in Access which is highly undesirable. I don't want any one to see the content of my table in mysql which is has no linked table in ACCESS.

How can I solve that?

regards