Transfer data from ACCESS to MySQL with PHP

halex

Hello guys,

Is it possible to get data from ACCESS database with PHP
and to store that data in MySQL database? For example, I make
upload of ACCESS file to server, PHP process it and gets data
and store data to MySQL database (ACCESS and MySQL databases
have the same structure).
Is there something already done about that issue (in order not
to do something that is already done)?

Thanks in advance

bastien

using csv or some text type file and just have php read it in...

much simpler to do

halex

I now that it is simplier, but I need Access. Why? My customers are connecting to internet using dial-up connection and they need a lot of time to add their adverts to site. It is much faster to add thet locally in Access (they know how to use it) and after thet they do upload of that file, PHP parse it and put data from ACCESS database to MySQL database.
Is it posible? I now that I can convert from ACCESS to CSV or similar format but I wanted automatization. :-)

Frag

Here this should get you started.

http://www.php.net/manual/en/printwn/faq.databases.php#faq.databases.access

Frag

RogerTM

If they have a dial-up they definitely should be converting the mdb to txt before they up-load. They can reduce their file size to 5-20% (depending if they compress).

The other benefit of having the your client convert to txt before they ship, is that when you migrate to linux you won't have this lump of MDB sitting there smelling the joint up!

I'm just starting on PHP, but I suspect that a program like Delphi (using ADO) or C++ will be doing the job much faster, than PHP (comments!). I've used Delphi 5 to do a similar type job and it is fairly painless (just stay away from the BDE). You can also write a script in Access to export all the tables to txt. So, if they want fast feedback on a large mdb you should create a utility on there side to as much work as possible.

Hope this helps
Roger

wigz01

Look into MyODBC:

http://www.mysqldeveloper.com/tutorials/index.pcgi?id=1