Importing Cash Book CSV files into Pastel Excel 2013

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Rodthebod
    New Member
    • May 2016
    • 3

    #1

    [Question] Importing Cash Book CSV files into Pastel Excel 2013

    Hi All

    I have just upgraded to Windows 13 and Office 13. Not so sure it was a good idea, but that is my opinion.

    Using the same templates as I have done for years, when importing either receipts, payments or a journal, i get the same message each time. 2account.

    It only shows these three errors, even though there are 52 lines of data in the CSV file.

    Some additional info. When I reopen the saved CSV file it opens as a comma seperated file, all data in the first cell and to see it as an Excel file I must use the Text to columns facility in excel to "read" the file properly.

    Is there atrick in Office 2013 that I am unaware of?

    What must I do to rectify this.

    Attached is an attachment of the first few line.
  • Neville Bailey
    Diamond Member

    • Nov 2010
    • 2786

    #2
    Go to Windows Control Panel and make sure your settings are as per my screenshot, specifically the List separator option.

    Click image for larger version

Name:	Screen Shot 2016-05-18 at 3.19.23 PM.jpg
Views:	1
Size:	55.1 KB
ID:	265018
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

    Comment

    • Dave A
      Site Caretaker

      • May 2006
      • 22803

      #3
      Originally posted by Rodthebod
      I have just upgraded to Windows 13 and Office 13.
      Just for clarity -

      Did you perhaps intend to say Windows 10 and Office 2013?
      Or do we have a time traveller amongst us?
      Participation is voluntary.

      Alcocks Electrical Services | Alcocks Pest Control & Entomological Services | Alcocks Hygiene Services

      Comment

      • Rodthebod
        New Member
        • May 2016
        • 3

        #4
        Yes you are correct. It is Windows 10 and Office 2013

        Comment

        Working...