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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289857 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
