Re: Re: Excel to MySQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux