How to import / read data from a csv file (comma separated) in coldfusion

Question

How to read data from a comma separated file (.csv file) in coldfusion? I have to read the contact information from the csv file and paste it into the database.

Thanks,
Yugal

Answer 1

Or, if you are on CF8, you can use UDF here http://www.bennadel.com/blog/2041-UPDATE-Parsing-CSV-Data-Files-In-ColdFusion-With-csvToArray-.htm

Answer 2

Here is an easy way to read in a CSV file - http://blog.dkferguson.com/index.cfm/2011/9/28/CSV-File-Reading-using-cfhttp

From there, you can simply program the query and insert each row into the database.