Chad, Excel is a binary type format so reading it with CFFILE isn't going to get your very far. You have 2 choice. The first one being have the client convert it to a CSV and then use something such as the Ostermiller library to parse the CSV into an array which you can then convert into a query.
http://ostermiller.org/utils/ExcelCSV.html The second would be to use the Apache POI Project that is a java API to access Microsoft formatted files such as excel. It will allow you to access the file directly without having to convert it to a CSV prior. http://poi.apache.org/ Hope that helps! J.J. On 10/1/07, Chad Gray <[EMAIL PROTECTED]> wrote: > 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:289856 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
