Re: Converting Excel Spreadsheet to MySQL table ...
| From: | Gurvinder Singh | Date: | Fri, 10 Jan 2003 23:09:17 +0000 |
| Subject: | Re: Converting Excel Spreadsheet to MySQL table ... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-131202@lists.php.net to get a copy of this message | ||
write a macro which will create a file with insert statments from the data
in the excel sheet.
run the macro get the file and run it on the linux box
Gurvinder Singh
www.gurvindersingh.com
<rblack@datavisibility.co.uk> wrote in message
news:OFC136F6B2.F56E7B76-ON80256CAA.003F673C@d-h.co.uk...
>
> If this is a one off excercise, ie you only have to do it once and
> afterwards things will be dealt with ENTIRELY through the MySQL database,
> you could save the spreadsheet as a CSV file and work with that.
>
> HTH,
>
> Richy
>
> ==========================================
> Richard Black
> Senior Developer, DataVisibility Ltd -
> http://www.datavisibility.com
> Tel: 0141 951 3481
> Email: rblack@datavisibility.co.uk
>
>
>
> Maxim Maletsky
> <maxim@php.net To: "Adam Ferguson"
<adam@adamferguson.com>
> > cc:
<php-general@lists.php.net>
> Subject: Re: [PHP] Converting
Excel Spreadsheet to MySQL table ...
> 10/01/2003
> 11:40
> Please respond
> to maxim
>
>
>
>
>
>
>
> Excel on its own is a compiled document. However, I think there was some
> way to do that. I remember I had to do it for MS Aceess files (Access ->
> mySQL) and i used a tool made by a brasilian guy, (someone remind me the
> name). I have the feeling that this is accomplisheable. Not sure if
> directly on Linux box...
>
>
> --
> Maxim Maletsky
> maxim@php.net
>
>
>
> "Adam Ferguson" <adam@adamferguson.com> wrote... :
>
> > Hello ...
> >
> > I was wondering if anyone had a good resource or code sample for opening
> ( or accessing ) an excel spreadsheet using php. I need to be able to
> convert a spreadsheet of products and info to a table of products in a
> mysql database. Also ... I need to be able to perform this on a Linux
> machine. Any help would be great.
> >
> > Thanks guys!
> > Adam Ferguson
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
> ________________________________________________________________________
> This email has been scanned for all viruses by the MessageLabs SkyScan
> service. For more information on a proactive anti-virus service working
> around the clock, around the globe, visit *%
> ?1http://www.messagelabs.com
> ________________________________________________________________________
>
>
>
>