I've recently been trying to do a large import of a Excel or CSV file generated from Excel. My efforts thus far have not been good and it's looking like I will have to reinvent the wheel.
I have yet to find a good article or paper on 1 Dynamic Datasources using coldfusions built in support of the ODBC Socket with excel. I was able to get my host to "add" a DNS of this type but haven't had any luck getting a query to run using it. So after giving up on the ODBC Socket I figured I'd google my luck on CSV and coldfusion. I have yet to find some one who does NOT assume that the data won't contain a comma. Which to me just seems ridiculous. Excel export to CSV puts "'s around rows with commas Example: "foo, bar", foo, bar would be 3 items the first being foo comma bar. However I have yet to find a good parser already written either in a UDF or even a CFC for any of this. If any one has any help out there it's much appreciated ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
