Re: [PHP-DB] 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 <[EMAIL PROTECTED]> [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:[EMAIL PROTECTED]] > Sent: Tuesday, May 22, 2001 5:01 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] web to access/excel
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:[EMAIL PROTECTED]] Sent: Tuesday, May 22, 2001 5:01 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]