about MS Access and MySQL

[rotan]

my server's os is RedHat 7.3, but i have a lot of data in MS Access on client. how can upload the data to mysql on my server and query the data on Access?
thanks a lot

 

[Robert]

Originally posted by rotan
my server's os is RedHat 7.3, but i have a lot of data in MS Access on client. how can upload the data to mysql on my server and query the data on Access?
thanks a lot

No. You would have to convert the data into a MySQL Database.. which I'm not sure if that's possible as I don't deal with Windows as a server OS.

 

[Gonzo]

Yes it is possible to do that, you could do it through php. PHP can read both databases.

I am pretty sure I have seen some programs on the net that can also convert Access into MySQL, just have a search on google.

 

[ashben]

U need http://www.bullzip.com/products/msa2mys/info.php

 

[Robert]

Originally posted by ashben
U need http://www.bullzip.com/products/msa2mys/info.php

That's neat. Thanks!

 

[rotan]

why

it show me "lost connection to mysql server during query"