RE: [PHP-DB] Excel to MySQL??
| From: | Jen Swofford | Date: | Sat, 29 Jun 2002 21:46:16 +0000 |
| Subject: | RE: [PHP-DB] Excel to MySQL?? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20204@lists.php.net to get a copy of this message | ||
Or if you don't use phpMyAdmin you can use LOAD DATA INFILE once you have
saved the Excel doc as a .csv file:
http://www.mysql.com/doc/L/O/LOAD_DATA.html
Jen Swofford
jen@littleduck.com
> -----Original Message-----
> From: Peter Lovatt [mailto:pjln1@sunmaia.net]
> Sent: Saturday, June 29, 2002 4:49 PM
> To: Chase; php-db@lists.php.net
> Subject: RE: [PHP-DB] Excel to MySQL??
>
>
> Hi
>
> from Excel export to csv
>
> use phpMyAdmin to load it into mysql (recent versions of phpMyAdmin has an
> Excel import function)
>
> HTH
>
> Peter
>
> -----------------------------------------------
> Excellence in internet and open source software
> -----------------------------------------------
> Sunmaia
> www.sunmaia.net
> info@sunmaia.net
> tel. 0121-242-1473
> -----------------------------------------------
>
> > -----Original Message-----
> > From: Chase [mailto:chase@ck2000.biz]
> > Sent: 29 June 2002 22:22
> > To: php-db@lists.php.net
> > Subject: [PHP-DB] Excel to MySQL??
> >
> >
> > Does anyone know of a way that I can export an Excel spreadsheet to a
> > file that I can import to MySQL? I found a program that will do this
> > for Access, but I would rather leave Access out of this if possible.
> > Thanks!!
> >
> > Chase
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>