http://www.emerle.net/programming/display.cfm/t/cfx_excel2query
 
works great - used to be free :(
 
Colin


From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Fricke
Sent: July 15, 2005 1:34 PM
To: CFLIST
Subject: import excel

Does anyone know of any good tools to import XLS using Coldfusion.  I would like to be able to give one of my clients the ability to upload several different spreadsheets into the new web app that we have built.  The only problem is that not all of the spreadsheets are formatted the same, i.e. one has a field name of "Established Date" and another has a field name of "Original Date" but they are going to import to the same field. 
 
Basically, I need a way to import excel into my mySQL database but I also need the ability to manipulate the file prior to importing.....
 
I haven't been able to find anything on the web.....yet.
 
Kevin

Reply via email to