Dusty, I have used the Java POI tool in the past. It's easy to implement, it is very fast (even at thousands of records and multiple worksheets) at reading/building an excel document.
I found this link on Ben Nadel's blog, he has built a nice cfc utility to do the work for you, you may just have change a few mappings. http://www.bennadel.com/blog/469-Creating-Microsoft-Excel-Files-Using-ColdFusion-And-POI.htm You should definitely be able to use it to read the excel file and then insert into the db, as far as a custom tag to do both (file upload & read), I do not have that. If you don't specifially need the file you can use the POI utility to read it on the fly and then import. Blake Blake Kiser UPS - Business Information & Analysis SCS - S530A 12380 Morris Rd. Alpharetta, GA 30005 (678) 746-4679, atlas 480-4679 ________________________________ From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Dusty Hale Sent: Friday, March 06, 2009 9:31 AM To: discussion@acfug.org Subject: [ACFUG Discuss] excel or csv to database table Hi I need to implement some CF code that does this and before I write all the code, I thought certainly there has got to be a custom tag or cfc that already does this: 1. Upload excel or csv file to server. 2. Import the excel sheet or csv file into a database table. I found an upload custom tag and now I am looking for any advise or recommendation on a custom tag or cfc or piece of code that will handle the import part. If anyone knows of a good solution for this, please share. Much appreciation! Thanks, Dusty ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
