IMPORTING CSV FILE TO PASTEL

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • SandiR
    New Member
    • Feb 2017
    • 2

    #1

    [Question] IMPORTING CSV FILE TO PASTEL

    Can anyone please help me. I am trying to import a csv cash book file to Pastel. I am getting the following error:

    Line 1 date must be in the format DD/MM/YYYY
    Line 1 invalid date
    Line 1 GDC field must be....
    Line 1 the contra account must be this cash book's contra account.....

    I have attached my csv file.

    Thank You
    Attached Files
  • Mike C
    Diamond Member

    • Apr 2012
    • 2892

    #2
    One of the very clever hints given on importing csv files is to export one from Pastel first, and then using that excel sheet and format insert your data and do the import. Don't know if that will help you, but I thought it a very clever suggestion as then you match the Pastel requirements perfectly.
    No act of kindness, no matter how small, is ever wasted. - Aesop "The Lion and the Mouse"

    Comment

    • Christel
      Silver Member

      • Feb 2012
      • 361

      #3
      SandiR... this file is not right... what bank is it? Maybe you should try and download it in another format?
      always fear when Christel is near....

      Comment

      Working...