Solved

Sage 50 and Open Office

Posted on 2014-04-10
4
1,238 Views
Last Modified: 2014-04-21
Greetings,

I have a client running a Windows 7 desktop and I installed Open Office. They are also running Sage 50 and have run into an issue. Sage 50 wants to generate reports to Excel and doesn't recognize calc.exe.

Does any know of a work around for this? It sounds like Sage just wants the MS product end of story, but my client a small plant nursery and I would hate to see them spend any more money than is needed.

Thanks.
0
Comment
Question by:Fuwaad
  • 2
4 Comments
 
LVL 37

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 39992955
I don't know about "Sage 50" but is it trying to send data directly to Excel? If that's the case you could try and associate .xls/xlsx with calc.exe (if that's not the case already).

Shift-Right-Click a .xlsx file and choose 'Open With', browse to 'calc.exe' and check the 'Always use the selected program ...'. Then try "Sage 50" and see if it works.
0
 
LVL 10

Expert Comment

by:Bruce Denney
ID: 39998559
You used to be able to read data from Sage via odbc the data pilot had issues with the SQL as it was ambiguous so you had to do it manually.  I tried it a short while ago and it didn't seem to work at all.

There are some other work around methods.

You can save (export) a report to csv format this can then be opened in any spreadsheet.

You can save (export) a report to excel format this will then be readable with open/libre office / others this will have formatting and not be as useful as plain csv for manipulation.
0
 

Accepted Solution

by:
Fuwaad earned 0 total points
ID: 40004954
My client informed me that they have Sage support paid for :-/   So I have contacted them. For anyone else who has this issue this is what I have been told by Sage second tier support.

The only way to create spreadsheets from Sage 50 data to have MS Excel installed. Even better it has to be installed locally in the workstation, AND it can't be 64 bit.

Thanks to Gerwin and Bruce for responding.

Onward and upward.
0
 

Author Closing Comment

by:Fuwaad
ID: 40012213
I get to grade myself? Well, I get an A because while I was right about what the issue was, and while I could not resolve it I'm not a programmer at Sage.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Excel Formula: How to increment-alphanumeric-column-by-1 Part 2 8 73
Need Free contact management program 9 106
Excel Score Formula 5 62
help with an excel problem 10 29
In this article I will provide some simple productivity hacks that will help you use Google to specifically show results from any web site (Experts-Exchange.com in my example), with minimal effort in Chrome and Firefox. I've seen a common theme a…
As freelancing is becoming more and more common in the tech industry, certain obstacles are proving to be a challenge to those who are used to more traditional, structured employment. This article is meant to help identify such obstacles and offer a…
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question