Re: Excel to MySQL
| From: | Kurt Lieber | Date: | Sat, 27 Oct 2001 18:49:53 +0000 |
| Subject: | Re: Excel to MySQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-72575@lists.php.net to get a copy of this message | ||
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