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
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,376
    Thanks
    35
    Thanked 393 Times in 340 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:	91 
Size:	55.1 KB 
ID:	6261
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    *** 20% DISCOUNT ON PASTEL XPRESS / PARTNER SOFTWARE UNTIL 15 DECEMBER 2017 ***

    "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
    20,979
    Thanks
    3,055
    Thanked 2,462 Times in 2,067 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?
    The trouble with opportunity is it normally comes dressed up as work.

  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. [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
  2. Replies: 1
    Last Post: 19-Nov-15, 08:33 PM
  3. Import Excel into pastel Cash book
    By ultramel123 in forum Accounting Forum
    Replies: 18
    Last Post: 23-Oct-15, 09:46 AM

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
  •