Fix Excel Power Query Access Violations with Sage Line 50 ODBC
Question details
Access Sage Line 50 table data in Excel when a direct Power Query ODBC connection returns an access violation.
- Product
- Microsoft Excel Power Query and Sage Line 50 ODBC driver
- Device & OS
- not provided
- Scenario
- The user wants to import a Sage Line 50 table into Excel through an ODBC driver.
- Observed behavior
- Power Query displays the Sage tables but returns an AccessViolationException when a table is selected.
Confirm that the Sage ODBC driver and a working data source name (DSN) are available. In Excel, open File > Account > About Excel to check whether Office is 32-bit or 64-bit.
Import Sage Line 50 data through Microsoft Query
Use this reported workaround to access the Sage driver without connecting directly through Power Query.
In Excel, select Data > Get Data > From Other Sources > From Microsoft Query. The menu location can vary by Excel version.
In Choose Data Source, select the Sage Line 50 DSN and click OK. Enter your Sage credentials if prompted.
Use the Query Wizard to choose the Sage table and columns you need, then proceed through the wizard.
Select Return Data to Microsoft Excel, click Finish, and choose where to place the imported data.

Check Office and Sage ODBC driver bitness
Use this check if Microsoft Query cannot connect or you want to test a different Sage driver version.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Excel format compatibility for an easier migration. It does not fix the Sage ODBC driver or Excel Power Query error.

Frequently Asked Questions
Why can I see Sage tables but get an access violation when selecting one?
Power Query may be able to list tables before the Sage ODBC driver fails while retrieving data. Try the Microsoft Query route in Excel to bypass the direct Power Query connection.
Can 64-bit Excel use the 32-bit Sage ODBC driver?
No. Excel needs an ODBC driver that matches its own bitness. Check File > Account > About Excel, then use the corresponding Sage driver and DSN.
Where do I find Microsoft Query in Excel?
Look under Data > Get Data > From Other Sources > From Microsoft Query. The location may differ depending on your Excel version.
Can I transform the imported Sage data in Power Query?
Yes. After returning the data through Microsoft Query, select a cell in the imported range and choose Data > From Table/Range to create a query from the Excel data.




