Power Query Problems

Fix Excel Power Query Access Violations with Sage Line 50 ODBC

Steven ParkerSteven Parker Nov 14, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

Import Sage Line 50 data through Microsoft Query

Use this reported workaround to access the Sage driver without connecting directly through Power Query.

1
Open Microsoft Query

In Excel, select Data > Get Data > From Other Sources > From Microsoft Query. The menu location can vary by Excel version.

2
Choose the Sage data source

In Choose Data Source, select the Sage Line 50 DSN and click OK. Enter your Sage credentials if prompted.

3
Select the data

Use the Query Wizard to choose the Sage table and columns you need, then proceed through the wizard.

4
Return data to Excel

Select Return Data to Microsoft Excel, click Finish, and choose where to place the imported data.

Import Sage Line 50 data through Microsoft Query
Using the data in Power Query: If you need Power Query transformations after import, select a cell in the imported range and use Data > From Table/Range. This starts from the Excel data rather than a direct Power Query ODBC connection.
Free Microsoft Office alternative

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.

Open and work with Excel XLSX and XLS filesReview Sage data that has been exported to a compatible spreadsheetUse a familiar spreadsheet interfaceGet a free, lightweight office suite
microsoft office alternative - wps office

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.