Re: Excel to MySQL
| From: | dav | Date: | Sun, 28 Oct 2001 12:03:37 +0000 |
| Subject: | Re: Excel to MySQL | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-72620@lists.php.net to get a copy of this message | ||
I use to save my access data to a dbf file and then use the dbf2mysql (see
www.mysql.com site).
dbf2mysql will create proper tables and export data to the mysql really
faster than odbc.
Very easy.
I have exported someting like 5.000.000 records into 8 differents tables in
4 hours (3 cdroms of access data, 1 cd of dbf data :)
And no need to create the table into mysql (this could be long if the table
is big).
Byez
"Daniel Harik" <gatop@hot.ee> ha scritto nel messaggio
news:17550864949.20011027231920@hot.ee...
> Guys getting more serious here now, 3 500 000 records, foxPro
>
> i'll try Jeff's method
>