I am looking for options (tools or methods) that will allow me to
update a mysql driven website from a local access database. The
local database will have far more info. but I want to be able to
extract pertinent info from this database to update the mysql
website database. What tools or methods are available and what are your recomendations?
Many Thanks
Peter
Since I don't know any other way to do it, I would export the data from Access in a delaminated text format and then use a script to import into to Mysql.
Read this -> http://www.devshed.com/Server_Side/MySQL/ODBC
//NoXcuz
I think that you need a macro that extracts the new data (found trough a timestramp or other) and inserts into mysql trough odbc link.
Hope this helps.
There are several Access-to-MySQL converters available:
http://www.mysql.com/downloads/contrib.html (In the 'Converters" section, there are several text files containing Access macros which create appropriate SQL statements for MySQL)
http://www.mysql.com/portal/software/html/software-37-1.html. (Some are freeware, some are commercial.)
Thank you everyone for your help. I not only found a nice
shareware access2mysql package which works both way very
well, but I also found the link:-
http://www.devshed.com/Server_Side/MySQL/ODBC
very usefull, it turns out I needed both the tool and the ODBC
connectivity.
Many Thanks
Peter Newton
i wonder if there's a way to have a permanent synchro between an access database and a mysql one?
From what i understand ODBC gives u the possibility to make the link between the two; is there a way to connect em permanently?
hi folks, here is one more tool to look at:
http://www.data-conversions.net
i like this one the most... having found this thread, hope to make an ad for them - great team with fast and good support... best regards :D