> I have a function that will do just that, its only like 22 lines of > code. > > You have to be careful because if you don't close the resource and > the > connection you have to restart your coldfusion services... so you may > want > to throw in a try/catch that does that. > > With this code you don't have to install any additional software or > anything... its all built-in coldfusion. I would copy/paste the code > but it > would likely mangle some characters so just copy/paste from the blog > site. > > > http://baughmansoft.com/index. cfm/20> 09/5/19/Pulling-an-Excel-file-into-a-query-struct-in-21-lines-of-code > > > > On Fri, Aug 7, 2009 at 10:59 AM, Donnie Carvajal < > [email protected]> wrote: > > > > > Hi Dan, > > > > Yes. Currently I am reading the uploaded CSV file with CFHTTP > which > > returns the data in a query. > > > > Thanks, > > > > Donnie > > > > >The end goal is to convert the file into a query-like struct that > you can > > >loop through taking action on the contents of each line? > > > > > >On Fri, Aug 7, 2009 at 10:41 AM, Donnie Carvajal < > > >[email protected]> wrote: > > > > > >> > > > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339577 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
