Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accpac Dos to Excel
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accpac Dos to Excel
Maybe something he
http://www.sageaccpac.com/products/o...aplusodbcLink/ -- Regards, Tom Ogilvy "Internet Pizza" <Internet wrote in message ... 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
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accpac Dos to Excel
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accpac Dos to Excel
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use Excel 2007 to generate Fr Reports in Accpac 5.0A? | Excel Discussion (Misc queries) | |||
How Excel & ACCPAC 6.1 calculate formulas???? | Excel Worksheet Functions |