Ah... now that is what im talking about! Thanks for the link Andrew, and Ben for the CFC!
-----Original Message----- From: Andrew Clark [mailto:[EMAIL PROTECTED] Sent: Monday, October 01, 2007 10:57 AM To: CF-Talk Subject: RE: import excel You could try this: http://www.bennadel.com/projects/poi-utility.htm -- Andrew -----Original Message----- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Monday, October 01, 2007 10:48 AM To: CF-Talk Subject: import excel What is the best way to handle taking in an excel sheet from a person. Then importing it into a database? I have a client that their data starts on excel and I don't want them to re-type it into our web app. It would be nice to import the data from excel directly into the database. Is this possible with <cffile> to read in the excel sheet and make it some kind of query object that I can loop over and insert into the database? Any ideas would be appreciated! Thanks, Chad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289870 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
