R: [PHP-DB] MSAccess2000 to MySql

Hi Ernesto, I'm not sure if I understood your question but, in order to connect MS Access on MySql you can use MyODBC that, installed in local box, it allows, for example, to import/export or simply linking in a .mdb one or more table from a local or remote MySql server. You'll found MyODBC download link on MySQL website. One suggestion: before use MyODBC, you must be sure: - to have the right permissions for your mysql user account (I mean: user_name@from_some_where or user_name@%) - to check if MS Access 2000 works fine with MyOdbc because in my experience is better to use MyODBC with Access 97 than Access 2000 Regards max > Hello, I'm developing a web site that displays some simple address info > from a MYSQL database. The thing is that the user has to enter the info > locally into a MSAcess2000 database. I would like to know if there is a > script (Win) that I could use to upload the info from this MSAccess to > the MySQL database. Basically the Access program will create 3 text > files, one for new entries, one for updated entries and one for deleted > entries, and I'm going to need to execute three queries against the > MySql db, any suggestions? Thanks