Importing a Text file

souravb
souravb Member Posts: 135
edited 2009-04-25 in NAV/Navision Classic Client
Hi,
I am importing a Text file through dataport. The file is tab delimited and no fieldstart and endlimiters are there. What setings i need on the dataport properties. Plz help

Comments

  • Kowa
    Kowa Member Posts: 927
    As FieldSeparator <TAB> and <None> for FieldStartDelimiter and FieldEndDelimiter.
    Kai Kowalewski
  • souravb
    souravb Member Posts: 135
    Hi,
    I have set it as you have mentioned. But only the last record of the text file is getting imported. The key of the table is Journal Template Name, Journal Batch Name and Line No.. All the fields are present in the text file. But only the last record is inserted in table. What can be the reason?.
  • kapamarou
    kapamarou Member Posts: 1,152
    Do you let the dataport handle the inserts or you insert the records through code?

Categories