x Want to participate? Join the group to interact

  • Sage 50 ODBC Connection

    I try to connect MS Excel to Sage file via ODBC. I got following message: Details: "ODBC: ERROR [IM014] The specified DSN contains an architecture mismatch between the Driver (32-bit) and Application (64-bit)" I am using Windows 10 64-bit. MS…

  • Excel processes don't end after exporting report from Sage and closing

    Having a problem for the last few months. We go to generate a report and once its up, we push the Open in Excel button, it opens and we can view the exported report. The issue is once excel is closed, it doesn't close the excel process in task manager…

  • Importing paypal invoices

    I am looking for a way to quickly enter the sales invoices from Paypal into sage. I can't find any info on a easy way to do this, but I did learn that sage can import excel files into sage. Would it be possible to download the sales log from paypal and…

  • Export to modern Excel format

    Why is Sage 50 still exporting to.xls? We just switched to Office 365, as Sage prefers. All the files need to be converted the first time i open them. It is such a pain and waste of time.

  • Sage 50 2016 Export to csv or open in excel data is not numeric

    I'm using Excel 2016, and just upgraded to Sage 50 Pro Accounting 2016 because the Sage sales guy said that it was compatible with Excel 2016. However, when doing "Open in Excel", it only shows the option of Excel 97 - 2007. After saving this .xls file…

  • Most people only use +/-5 percent of Excel

    I've seen some people really struggle with Excel, but minus 5 percent is a pretty harsh grade.

  • Please Help - Importing Historical Data from Excel?

    Hello! We have just begun using Sage and we are going to be closing out month here and Importing all open historical information so that starting April 1st we will be current. The idea is to run sage side by side with our current software for the rest…

  • RE: Query for job costing across three databases

    Well, this has proven to be a bit of a wild goose chase so far! I've had a few offline discussions with Richard Ridings as well, and I now have a query that works fine (thanks Richard!) - as long as it is run manually. I can run all three - manually…

  • Query for job costing across three databases

    I would like to construct an SQL query, which dumps to Excel, an analysis of the job costing for a range of jobs across three different organizations. All have virtually identical structures and naming conventions. There is not a ton of data to grab,…

*Community Hub is the new name for Sage City