Solved

Sage 50 and Open Office

Posted on 2014-04-10
4
1,269 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 38

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

Create the perfect environment for any meeting

You might have a modern environment with all sorts of high-tech equipment, but what makes it worthwhile is how you seamlessly bring together the presentation with audio, video and lighting. The ATEN Control System provides integrated control and system automation.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Companies keep a much closer eye on costs today, so changing to new Technology – Microsoft Office 365 is the smartest move to take.
The viewer will learn how to edit text. This includes Font, Spacing, Resizing, Color, and other special text options.
This video walks the viewer through the process of creating an MLA formatted document, as well as a bibliography with citations.

820 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