You could use the Excel ODBC driver, or import directly into Access and then work some magic.
I'm assuming you're working in Windows since we're talking aobut Excel. - Matt >You could try this: http://www.bennadel.com/projects/poi-utility.htm > >-- Andrew > >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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289859 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
