Another way is to export the Excel data as a tab-delimited text file and then read the file's content and parse it with this UDF:
http://www.cflib.org/udf.cfm?ID=855 Good luck! > >This will get you there: > > > >http://www.emerle.net/programming/display.cfm/t/cfx_excel2query > > While that looks like it's exactly what I need, I have to access to > the cold fusion server, but only to my htdocs area. So it looks like > I can't do this line: > > 1. Add the supplied cfx_Excel2Query.jar file to your Java/JVM class > path. > e.g. c:\cfusionmx\cfx_tags\cfx_Excel2Query.jar' > > and then restart CFMX. > > But it is exactly what I needed otherwise, thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203943 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
