Re: web to access/excel

You can write "excel" files (ie files that excel associates with, if you have it) very easily by just using a .csv extension, and the following type format: "field1", "field2", "field3" (ie print "\"field1\",\"field2\",\"field3\""; ) Excel will display this as if it were a "spreadsheet". If you need to get more fancy than this, you could create something to write .dif files (again, a text based format.) Ken * Jonathan Hilgeman <JHilgeman@ecx.com> [010522 10:16]: > Hi Russ, > Try this package: > http://phpclasses.upperdesign.com/browse.html/package/237 > > You need to register for free to gain access, but this package is supposed > to write Excel binary files. > > Jonathan > > -----Original Message----- > From: Russ Michell [mailto:r.j.michell@apu.ac.uk] > Sent: Tuesday, May 22, 2001 5:01 AM > To: web-support@jiscmail.ac.uk > Cc: php-db@lists.php.net > Subject: [PHP-DB] web to access/excel > > > *****Apologies for cross-postings****** > > Hi there all: > > Does anyone know of a product - preferably free, that once > installed, can take info from an ordinary HTML web based form and > drop it into an access/excel database/spreadsheet?? or a > pre-defined/written script or class written for Apache/php4/MySQL that > has the information filtering and sorting capabilites of excel/access?? > > One of our departments urgently requires such functionality to increase > processing times of student enquiries. At present the information from > the students is in a non-standardised format in the form of an email > that has to be processed by hand. > > The data needs to be formalised from a structured online form, and > inserted into an access/excel type 'environment' that current > (non-web technical) administrators are familliar with. > > Any suggestions are most welcome. > > Again I apologise for the cross posting but this is a pressing matter, > that requires I find a pointer to a solution, or an actual solution > as fast as I can! > > Kind regards: > Russ > > > > #-------------------------------------------------------# > > "Believe nothing - consider everything" > > Russ Michell > Anglia Polytechnic University Webteam > > e: r.j.michell@apu.ac.uk > w: www.apu.ac.uk/webteam > t: +44 (0)1223 363271 x 2331 > > www.theruss.com > > #-------------------------------------------------------# > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net