Results 1 to 4 of 4

Thread: Importing Cash Book CSV files into Pastel Excel 2013

  1. #1
    New Member
    Join Date
    May 2016
    Location
    Pretoria
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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.

  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    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:	456 
Size:	55.1 KB 
ID:	6261
    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)

  3. #3
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    22,648
    Thanks
    3,304
    Thanked 2,676 Times in 2,257 Posts
    Blog Entries
    12
    Quote Originally Posted by Rodthebod View Post
    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?

  4. #4
    New Member
    Join Date
    May 2016
    Location
    Pretoria
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Yes you are correct. It is Windows 10 and Office 2013

Similar Threads

  1. Import Excel into pastel Cash book
    By ultramel123 in forum Accounting Forum
    Replies: 20
    Last Post: 20-Jun-19, 12:20 PM
  2. [Question] Importing Excel files to Pastel for invoicing purposes
    By JacoDif in forum Accounting Forum
    Replies: 0
    Last Post: 27-Jan-16, 10:38 AM
  3. Replies: 1
    Last Post: 19-Nov-15, 08:33 PM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •