Excel with VB for Applications (VBA) Fails With ORA-01445 cannot select ROWID (Doc ID 1293763.1)

Last updated on JULY 05, 2017

Applies to:

Oracle ODBC Driver - Version 8.0.6.0 and later
Generic Windows
***Checked for relevance on 23-Jan-2013***

Symptoms

You are using Microsoft Excel to generate reports using data from Oracle.  You are writing the code to generate these reports using Visual Basic for Applications (VBA) and the Oracle ODBC Driver.  When you attempt to run your report you receive the following error:

     -2147467259: [Oracle][ODBC][Ora]ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table

The report fails to complete.  Other reports may run fine.  This may also occur when using Microsoft Access, VBA and the Oracle ODBC Driver.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms