RE: [PHP-DB] Excel to MySQL?? From: Jen Swofford (jen <email protected>)
Date: 06/29/02

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 <email protected>

> -----Original Message-----
> From: Peter Lovatt [mailto:pjln1 <email protected>]
> Sent: Saturday, June 29, 2002 4:49 PM
> To: Chase; php-db <email protected>
> 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 <email protected>
> tel. 0121-242-1473
> -----------------------------------------------
>
> > -----Original Message-----
> > From: Chase [mailto:chase <email protected>]
> > Sent: 29 June 2002 22:22
> > To: php-db <email protected>
> > 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
>
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php