4 Replies Latest reply: Nov 21, 2015 10:02 AM by Marcus Sommer RSS

    .txt file not uploading fully

    Mahm Tamal

      Hi All,

       

      I have a .txt file that I'm pulling the data from. It has 130k lines in it, QV is only importing 90k of these lines. I tried some other .txt files as well, it's always doing the same thing, not importing the entire file.

       

      When I open my .txt in Excel and save it as .xlsx file and then import it, then it works but I have to do it every day. Anyone's got an idea how to fix this?

       

      Here is my import script:

       

      LOAD IMPORT_DATE,

           WEEK_NO,

           SKU,

           QTY

          

      FROM

      [\\ant\daily_extracts\Demand.txt]

      (txt, codepage is 1252, embedded labels, delimiter is '\t', msq);