6 Replies Latest reply on Jul 30, 2013 2:43 PM by BKBK

    CF10 - CFLoop with a File - Only read in first row




      I'm trying to read the header row from a very large(83k) tab delmited file.  I want to automate an upload to a temp table to append data, but I need to know the column headers to set up the table for Bulk Insert.


      How can I read in the only the first row?  CFSpreadsheet doesn't work with XSLX files, especially 83k row ones, it would just crap out.  So I'm going the tab delmited route here.