All seems fine until one decides to connect to their 32-bit ODBC and are greeted by the “Specified DSN contains and architecture mismatch”.Do you need better visibility to your company data? Our cloud and mobile construction software solutions provide real-time reports and 20/20 vision into every facet of your business including estimating. It’s more than just a website builder, it’s how your vision comes to life. (if you can’t see Sage in this list, try the Excel 97 method. To make the connection, take the following steps: From the Power Query Get Data dialog (or Data tab in the Excel ribbon), select Database > ODBC.
The problem I have is that I have a massive P&L and Balance Sheet due to all of the nominal codes being listed even though they do not have values. After signing in, we'll redirect you back here. Connect excel to sage 50 Sage 50 vs QuickBooks: The Best Accounting Software for Your Small Business.