I have a large mdb file, which I want to upload to the server (linux) and store the data from it to my MySql database using a PHP program. As Linux server does not support Access files, how can I make it possible ? How can I convert mdb file to csv using PHP ? Please help me.
I think he means from your desktop convert it to CSV from MS Access. Seriously there are easier ways to do things then try and make some program in PHP when the original application can do it already.
can you give us some more details?
i am not getting why you want to store mdb files in server.do onething convert mdb files to mysql using ‘JeffGSR’ method and write a mysql query using php.so the problem solved
The ADODB package has drivers available for .mdb files. I presume you can back this .mdb file up from your linux server. Ftp your database back up file to your server, then open using the ADODB package. Read a line and write it to your MySQL database. If you need a ready to run solution post your database table layout to this thread and someone will cut you the working code.
But, I need read .mdb file in the server, in the web.
I don´t have the access database in the server.
I only have the .mdb file and I can´t to modify it before the sending.
I can’t use softwares in the machine, I think in to use PHP script, but I don’t know I eat to develop it.
This process of reading will have every day to be executed automatically in the server for to bring up to date MySQL db.