access to mysql using PHP

indian_ute

Hii Theree

I have an access database on a lcient machine . I want to transfer the same database using PHP on the server into a MySql database theree. Can anybody suggest me how to do this or also tell me any link for this.

Thanks so much

indian_ute

kevinsequeira

use myodbc to transfer the access database directly to mysql, no need to use php

http://www.mysql.com/downloads/api-myodbc.html

tutorial here

http://www.phphelp.com/tutorial/using-myodbc-to-connect-to-a-remote-database.html

reg
kevin

indian_ute

Hii Kevin

Thanks so much for your help. but i have to make a PHP page for doing this . That is what the application demands. I have to upload the data on the server thorugh a PHP page . Is there a way for doing this kind of thing. Somewhere i read i could make a SQL file using php and then transfer it and then download it.

Can u tell me how

Thanks so much

indian_ute

nnichols

If you are running the server on a Windows machine you can use COM to access the data in the Access db and transfer it that way (don't have a clue how, but you can).

If you are running on a Linux box you will need to export a csv file and then write a script to input the data from the uploaded csv file into your db.

If the object is to allow the client to synchronize their local db to the remote MySQL db you could use myodbc and write a macro in access to synchronize the two.

What is the objective and how much data needs to be transferred? How often?