Tags: accpac, canada, charity, clients, dos, excel, microsoft, msdn, plus, software, toronto

Accpac Dos to Excel

On Microsoft » Microsoft Excel

4,049 words with 3 Comments; publish: Fri, 23 May 2008 01:54:00 GMT; (306187.50, « »)

Hello, we have some charity clients in Toronto, Canada who are using Accpac

Plus in Dos.

How can we send data from Accpac Plus / Dos to Excel or can you suggest a

program that Excel can use to import data from Accpac Dos?

The clients want to send AR, AP and GL details with the field names to Excel.

Thank you for your assistance

All Comments

Leave a comment...

  • 3 Comments
    • Maybe something here:

      http://www.sageaccpac.com/products/options/aplusodbcLink/

      --

      Regards,

      Tom Ogilvy

      "Internet Pizza" <Internet Pizza.excel.questionfor.info.discussions.microsoft.com> wrote in message

      news:AC485632-F7A3-49FC-8EC5-9888316E20AB.excel.questionfor.info.microsoft.com...

      > Hello, we have some charity clients in Toronto, Canada who are using

      > Accpac

      > Plus in Dos.

      > How can we send data from Accpac Plus / Dos to Excel or can you suggest a

      > program that Excel can use to import data from Accpac Dos?

      > The clients want to send AR, AP and GL details with the field names to

      > Excel.

      > Thank you for your assistance

      >

      #1; Fri, 23 May 2008 01:55:00 GMT
    • Assuming that there are no options for the reports to be saved as CSV (comma

      seperated values) or such.

      You are limited to saving them as text files and if you can't save the files

      as a text file set up a printer as a generic text printer and print through

      that printer and save to file.

      You then need to use a converter like monarch

      http://www.datawatch-europe.com/products.shtml

      or prompt (parse-o-matic)

      http://members.aol.com/getmydata/pc-index.html

      or you could write the converter in excel vba.

      good luck as the process can be time consuming.

      Hope this helps

      Martin Fishlock

      Please do not forget to rate this reply.

      "Internet Pizza" wrote:

      > Hello, we have some charity clients in Toronto, Canada who are using Accpac

      > Plus in Dos.

      > How can we send data from Accpac Plus / Dos to Excel or can you suggest a

      > program that Excel can use to import data from Accpac Dos?

      > The clients want to send AR, AP and GL details with the field names to Excel.

      > Thank you for your assistance

      >

      #2; Fri, 23 May 2008 01:56:00 GMT
    • Thank you for your suggestions.

      The charity I am working with has decided to continue looking for a

      finished software package, but in the meantime is now looking for an

      ODBC link between Accpac & Excel.

      Have a nice holiday

      ===

      Martin Fishlock wrote:

      > Assuming that there are no options for the reports to be saved as CSV (comma

      > seperated values) or such.

      > You are limited to saving them as text files and if you can't save the files

      > as a text file set up a printer as a generic text printer and print through

      > that printer and save to file.

      > You then need to use a converter like monarch

      > http://www.datawatch-europe.com/products.shtml

      > or prompt (parse-o-matic)

      > http://members.aol.com/getmydata/pc-index.html

      > or you could write the converter in excel vba.

      > good luck as the process can be time consuming.

      >

      > --

      > Hope this helps

      > Martin Fishlock

      > Please do not forget to rate this reply.

      >

      > "Internet Pizza" wrote:

      > > Hello, we have some charity clients in Toronto, Canada who are using Accpac

      > > Plus in Dos.

      > >

      > > How can we send data from Accpac Plus / Dos to Excel or can you suggest a

      > > program that Excel can use to import data from Accpac Dos?

      > >

      > > The clients want to send AR, AP and GL details with the field names to Excel.

      > >

      > > Thank you for your assistance

      > >

      #3; Fri, 23 May 2008 01:57:00 GMT