Fix Snowflake ODBC Connection Errors in Excel Power Query
Question details
The user needs to resolve Snowflake ODBC connection crashes and access violation errors in Excel Power Query so that Snowflake queries load consistently.

- Product
- Microsoft Excel Power Query and Snowflake ODBC driver
- Device & OS
- not provided
- Scenario
- A user is querying Snowflake from Excel Power Query through an ODBC connection; similar queries may work differently or trigger crashes.
- Observed behavior
- Power Query fails with an access violation such as error code 0xC0000005, or the connection crashes when running the query.
Before changing drivers, close all Excel and Power Query windows, note the current Snowflake ODBC driver version and bitness, and make sure you have administrator rights to install or update the ODBC driver.
Update the Snowflake ODBC Driver and Recreate the Power Query Connection
Use this first when Power Query crashes or returns error 0xC0000005; an outdated or mismatched Snowflake ODBC driver is the most common cause.
Excel Power Query calls the Snowflake ODBC driver directly, so a driver that is older than the connector version, or a 32-bit/64-bit mismatch, can lead to access violations like 0xC0000005.
Open the Windows ODBC Data Source Administrator, select the Snowflake DSN, and note the driver version and platform shown on the Drivers tab.
Go to the Snowflake developer downloads page at https://www.snowflake.com/en/developers/downloads/odbc/ and download the driver that matches your Excel bitness.
Run the installer with administrator rights, then reopen the ODBC Data Source Administrator to confirm the new driver version is listed.
In Excel, open Power Query Editor, delete the existing Snowflake connection or data source, and create a new connection using the updated DSN or Snowflake connector.
Run a basic SELECT statement first, then add the WHERE clause from the failing query to verify that the query returns data without triggering the access violation.

Match ODBC Driver Bitness and Validate Connection Settings
Use this when the latest driver is installed but the connection still fails, or when the DSN is visible in one ODBC Administrator but not the other.
Isolate the Query That Triggers the Snowflake ODBC Access Violation
Use this when similar queries behave differently or only a specific SQL statement crashes; it helps identify the unsupported expression or filter.
Use WPS Office to Work with Snowflake Exports Without Excel Power Query Crashes
When Excel Power Query and the Snowflake ODBC driver continue to fail, WPS Office gives you a free, lightweight environment for opening, analyzing, and sharing the exported data with familiar spreadsheet tools and .xlsx compatibility.

Frequently Asked Questions
Why does Excel Power Query crash with Snowflake ODBC error 0xC0000005?
This access violation usually indicates an outdated Snowflake ODBC driver, a mismatch between 32-bit or 64-bit Excel and the driver, or an unsupported native SQL clause. Update the driver, match the bitness, and test the SQL query.
How do I know whether to install the 32-bit or 64-bit Snowflake ODBC driver?
Check Excel via File > Account > About Excel. Install the Snowflake ODBC driver that matches your Excel installation: 64-bit Excel requires the 64-bit driver, and 32-bit Excel requires the 32-bit driver.
Where can I download the latest Snowflake ODBC driver?
Download it from the official Snowflake developer downloads page at https://www.snowflake.com/en/developers/downloads/odbc/. After installing, verify the version in the ODBC Data Source Administrator.
Do I have to recreate my Power Query after updating the Snowflake ODBC driver?
It is recommended to recreate or refresh the connection so Excel Power Query picks up the new driver. Then test a basic SELECT statement before re-adding the original WHERE clause.
Can WPS Office use Snowflake data if Excel Power Query keeps crashing?
WPS Spreadsheets can open .xlsx, .xls, and .csv exports and has data import tools. It is not a Power Query replacement, but you can use it to continue reviewing and sharing Snowflake-exported data.




