Importing a Text file

souravbsouravb Member Posts: 135
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

  • KowaKowa Member Posts: 923
    As FieldSeparator <TAB> and <None> for FieldStartDelimiter and FieldEndDelimiter.
    Kai Kowalewski
  • souravbsouravb 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?.
  • kapamaroukapamarou Member Posts: 1,152
    Do you let the dataport handle the inserts or you insert the records through code?
Sign In or Register to comment.