Results 1 to 6 of 6

Thread: exporting data in pastel to excel

  1. #1
    Email problem
    Join Date
    Aug 2012
    Location
    durban
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    exporting data in pastel to excel

    I'm currently doing voluntary work at an organisation and need the data that is in Pastel exported to Excel so that I can use it easier. And re-arrange it etc.
    I'm very familiar with Excel but have never used Pastel.
    Anyone able to help with very explicit directions?

  2. #2
    Diamond Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Umkomaas
    Posts
    2,850
    Thanks
    249
    Thanked 371 Times in 327 Posts
    Hi Berhardshap. What version of Pastel are you running - and what data in particular are you wanting to export?

    The best way to get data to Excel is to go to view, select the information you want, and instead of selecting print to "screen" you use the drop down menu to select "Excel".
    No act of kindness, no matter how small, is ever wasted. - Aesop "The Lion and the Mouse"

  3. #3
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Apart from Mike suggestion, you might want to consider getting the Business Intelligence Centre (BIC) module, which will allow you to set up template report layouts in Excel which are dynamically linked to your Pastel database.

    You can then literally produce Excel reports at a press of a button.

    Drop me an email if you would like to know more about BIC.
    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)

  4. #4
    Email problem
    Join Date
    Aug 2012
    Location
    durban
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks. I did it this morning and it all worked out fine. They are using Pastel Partner 2009.
    Having a bit of a problem saving it to my flash drive. Going back there tomorrow and hope i can sort it all out.
    Regards,
    Bernard

  5. #5
    Silver Member Christel's Avatar
    Join Date
    Feb 2012
    Location
    Port Elizabeth
    Posts
    360
    Thanks
    57
    Thanked 96 Times in 68 Posts
    I would like to know how to export the CASH Book to Excel, so that the client can load his data, and I can import it back into Pastel and just fix up errors. I know it's possible...
    Thanks.
    always fear when Christel is near....

  6. #6
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    I have attached the CSV layout that Pastel requires in order to import a cashbook journal.
    Attached Files Attached Files
    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)

  7. Thanks given for this post:

    Christel (29-Aug-12)

Similar Threads

  1. Replies: 1
    Last Post: 22-Jun-12, 07:30 PM
  2. Pastel statements - Excel
    By KimH in forum Accounting Forum
    Replies: 7
    Last Post: 27-Sep-11, 12:12 PM
  3. Pastel Partner to Excel Auto mapping
    By tyrone k in forum Technology Forum
    Replies: 2
    Last Post: 11-May-09, 04:59 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
  •