> Hey, that's pretty cool. Your method does work very well provided > you're looking at well formatted, query like data (like a quality CSV) > and the file is accessible via http.
One way to get around poor quality CSV is similar to getting around poor quality WSDL(?) type stuff... grab the file, parse it locally, re-save it, and then point cfhttp at it. I have to do this for one site that has tabs and weird chars in the CSV file. Works great. I also have some code that will take a "real" excel file (not CSV) and import it using jexcelapi. Used it with 11000 rows so far, takes about 10seconds. Turns it into a table or a query, IIRC... and it will pull out all of the workbook spreadsheets. Been meaning to finish off my "how to create a" entry with a "how to import" one... sad, sad blog: http://loggedden.blogspot.com. Big thanks to whover wrote the coloredcode bit of blogCFC... :-) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252310 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
