Export to MySQL?

[martinmike2]

Hello, I can't install the MySQL ODBC Driver due to usage rights so I
cant use the export method. I have tried to use the MySQL GUI
Toolkit, but I cant get connected to the MySQL server I am going to
use. I have tried exporting to .txt in CSV format and importing, but
no good.

Any ideas?

 

[Douglas J. Steele]

If you can't install the ODBC driver, you can't communicate from Access to
MySQL.

Your only option becomes exporting from Access to some format MySQL will
recognize, and importing from that into MySQL. If you can't connect to the
MySQL server though, I don't see how you'd be able to do anything with it.

 

[a a r o n _ k e m p f]

if I were you-- I'd just use a database server with a future-- SQL
Server
moving to mySQL would give you _MORE_ complexity than leaving it in
Jet.

Access Data Projects are much much simpler solution

It looks just like Access-- but you store everything in SQL Server =
'ADP'

File, New, Project (New Data), Choose a Server

-Aaron

 

[Aaron Kempf knows nothing]

if I were you-- I'd just listen to a person with a future-- definitely not me