Re: Re: Excel to MySQL
| From: | Balwant Singh | Date: | Tue, 25 Jan 2005 10:54:11 +0000 |
| Subject: | Re: Re: Excel to MySQL | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-38314@lists.php.net to get a copy of this message | ||
As suggested by David, save the excel file as CSV file then you can
insert the data into database through command like LOAD INFILE for MYSQL
with best wishes
balwant
On Tue, 2005-01-25 at 12:34, David Robley wrote:
> On Tuesday 25 January 2005 08:07, Novice Learner wrote:
>
> > Hello,
> >
> > I have an Excel worksheet with a database in it. I would like to move this
> > data to the database on the server that would work with my .php files.
> >
> > Is there a way?
> >
> > I apologize if I posted this question on the wrong list.
> >
> > Thank you,
>
> One option might be to export the Excel data as csv, then use whatever
> option your database provides to import the csv data.
>
> --
> David Robley
>
> Nostalgia isn't what it used to be.