exporting data in pastel to excel

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bernardshap
    Email problem
    • Aug 2012
    • 3

    #1

    [Question] 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?
  • Mike C
    Diamond Member

    • Apr 2012
    • 2892

    #2
    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"

    Comment

    • Neville Bailey
      Diamond Member

      • Nov 2010
      • 2786

      #3
      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)

      Comment

      • bernardshap
        Email problem
        • Aug 2012
        • 3

        #4
        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

        Comment

        • Christel
          Silver Member

          • Feb 2012
          • 361

          #5
          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....

          Comment

          • Neville Bailey
            Diamond Member

            • Nov 2010
            • 2786

            #6
            I have attached the CSV layout that Pastel requires in order to import a cashbook journal.
            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)

            Comment

            Working...