I encountered some problems with ColdFusion 8/9/10 reading a CSV file that was created using Excel. The only solution that worked involved using opencsv, a Java parsing library. Here's the CFML code that I used to convert the results (a 2 dimensional array) to a ColdFusion query. (NOTE: OpenCSV is also the best solution if your Excel file has multi-line data in columns.)
NOTE: This is a Tumblr repost from 2013.
Top comments (0)