On Saturday 27 October 2001 17:11, Daniel Harik wrote: > You see i have huge(for me) 100 000 record access table, i wanted to > convert it to mysql, i thought of making php convertor that uses odbc > and mysql, but maybe there is faster way?
Your subject says "excel" but above, you say "access". If, in fact, you want to convert from access to mySQL, then forget about importing/exporting. Just grab this access module: http://www.rot13.org/~dpavlin/projects/sql/exportSQL3.txt It exports a native mySQL script that creates all your tables, indexes, primary keys and then imports your data. It absolutely kicks butt. I've used it several times and have never had a problem with it. It's a very slick solution. --kurt -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
