database conversion

mlepiouf

Hi, does someone knows how to convert an access DB to a MySQL DB using php ?
Thanks

reidme

$search_engine = 'http://google.com';
$search_string = 'MS access to Mysql converter php';
"$search_engine"."$search_string";
$results = LOTS! 😃

http://help.webstorage.com/mysql.html
that any good?

mlepiouf

Thanks man,

But I only found module in Access code, although I do need to do the conversion in php. How to ?

Originally posted by reidme
$search_engine = 'http://google.com';
$search_string = 'MS access to Mysql converter php';
"$search_engine"."$search_string";
$results = LOTS! 😃

http://help.webstorage.com/mysql.html
that any good?

nnichols

Sorry. I hadn't read your previous posts.

Why don't you use MySQL-Front? It does a good job of taking data from an ODBC source and shoving it into mysql.

It would be a lot simpler than using php to read from the ODBC connection and then creating the db on mysql.

mlepiouf

Thanks for your help !

I'm working on my personal computer (DB & tools under 'windows me' in it) with easyphp which launch everything to work (Apache, MySql, Php) under windows me .

What I need to do is to convert an Access Database to a MySql DB.

The Access DB is a very simple DB with no links between tables, its is only tables, made of several columns.

I try to get every thing from the DB (name : ICAM.mdb) via an ODBC link. I saw weird converters that didn't worked anyway.

So now I'm working on a php code, which connects to the Access DB via ODBC (ICAM) , creates a MySql DB (db1).
I succeed to get every tables in ICAM and to create them in db1.
I succeed to get every columns from every tables in ICAM and to ceate them with the correct type and length.
Now I can't get rows of columns (actually I get only the first row, others disappeared 😃 ) . So I can't get the data in the tables, this makes my converter unuseful at all !!!

If you can, help me please🙁

Cong

I agree, mySQLfront would be the simplest way to go. Just create the tables in mySQL manually and then export your data in Access as csv, import it into mySQL either by a script or using mySQLfront.

mlepiouf

What is MySql-front ? where can I find it ?

thank you, thank you, thank you !!!!!

nnichols

This is a link to the actual donwload - Download MySQL-Front here

Good luck!

mlepiouf

I just got it, and it works fine (although some troubles because of spaces in fields that I'll have to filter).

Thank you for your support, and Merry Christmas !🙂

nnichols

And -

A Merry Christmas and A Happy New Year to you 😉