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

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

    SGroty

      Hi,

       

      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.

       

      Thanks