Re: Excel to MySQL
| From: | Sam | Date: | Sat, 04 Jan 2003 00:05:41 +0000 |
| Subject: | Re: Excel to MySQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-130177@lists.php.net to get a copy of this message | ||
> Does anyone know of a FREE utility that will export data from an MS
> Excel file and import it to MySQL. I have found a bunch of nice
> utilities, but none of them are FREE. I'm in a bind and have to get
> over 2000 rows imported to my database by morning and don't have to
> order one of the other solutions.
>
Maybe you can use this:
Save the Excel document as tab delimited text and use the mysql command LOAD
DATA or the mysqlimport utility.
mysql> LOAD DATA INFILE 'data.txt' INTO TABLE table;
<http://www.mysql.com/doc/en/LOAD_DATA.html>
You'd better check out the stuff about "enclosed by".