[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]
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]
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]
