Interesting I hadn't considered a windows ODBC. It seems there are about 200 ways to skin this cat. I prefer the ad-hoc java driver for creating an ODBC datasource, but I guess it might not work for the new-fangled XLSX stuff.
On Fri, Aug 7, 2009 at 11:30 AM, Mark Kruger <[email protected]> wrote: > > Dan, > > > Yes.... I thought you had mentioned a CSV file. > > The same approach will work with excel - you would just need a different > driver. > > Check out Ryan's post: > > http://www.stillnetstudios.com/garbled-truncated-reading-xls-files/ > > > Mark A. Kruger, CFG, MCSE > (402) 408-3733 ext 105 > www.cfwebtools.com > www.coldfusionmuse.com > www.necfug.com > > -----Original Message----- > From: Dan Baughman [mailto:[email protected]] > Sent: Friday, August 07, 2009 11:22 AM > To: cf-talk > Subject: Re: Excel File Parser for ColdFusion > > > It appears that approach wants to work with a CSV file, not an xls? > > On Fri, Aug 7, 2009 at 11:17 AM, Mark Kruger <[email protected]> > wrote: > > > > > Well here's one approach. Keep in mind that CF9 will have some good > > features for this sort of thing. > > > > > > http://www.coldfusionmuse.com/index.cfm/2007/2/5/csv > > > > -Mark > > > > > > > > Mark A. Kruger, CFG, MCSE > > (402) 408-3733 ext 105 > > www.cfwebtools.com > > www.coldfusionmuse.com > > www.necfug.com > > > > -----Original Message----- > > From: Donnie Carvajal [mailto:[email protected]] > > Sent: Friday, August 07, 2009 10:59 AM > > To: cf-talk > > Subject: Re: Excel File Parser for ColdFusion > > > > > > 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: > > > > > >> > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325281 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
