Re: Excel / my SQL

 > We have a client who wants to pull his MS Excel file into his website.
 > Currently he is on a IIS server - but he wants to switch to an Unix server
 > so that we can pull it in through PHP.

Actually there is no need to switch to Unix (At least no reason to switch on
this account...). Both PHP and mySQL run perfectly well on IIS.

However to convert an excel file to a database will require a little bit of
work! I know that if you use ASP there are special objects available that
will directly read your Excel file, and this may be the way to go if you
need to do this on the fly.

To create a static page from an Excel spreadsheet see


'Creating Web Pages to Display Excel Data'
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html
/deconcreatingwebpagestodisplayexceldata.asp

Also there is a ton of stuff if you search under 'Excel' on
http://msdn.microsoft.com

HTH

Frank

----- Original Message -----
From: "Mike Taylor" <lonewolf(at)one.net>
To: "Tamara Nelson" <tamara(at)sanctusmoo.com>
Cc: <hwg-techniques(at)hwg.org>
Sent: Wednesday, January 30, 2002 1:39 PM
Subject: Re: Excel / my SQL


 > There likely is, since we do the same thing with CSV files, importing
 > them into SQL using ASP.
 >
 > You should be able to hunt down info at www.php.net
 >
 > In fact, I see a function there that might help:
 > http://www.php.net/manual/en/function.fgetcsv.php
 >
 > Mike
 >
 >
 > On Wed, 30 Jan 2002, Tamara Nelson wrote:
 >
 > > We have a client who wants to pull his MS Excel file into his website.
 > > Currently he is on a IIS server - but he wants to switch to an Unix
server
 > > so that we can pull it in through PHP.
 > >
 > > I've read up a bit on PHP and mySQL, but I'm not sure I'm understanding
it
 > > well.
 > >
 > > Is it true that I can import a CSV file (created by Excel) into mySQL
using
 > > PHP?
 > >
 > > I think I need my hand held...
 > > TIA,
 > > Tamara Nelson
 > >
 > >
 > >
 >

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA