This week I was building power pivot models for a client pulling data from Oracle. One table kept giving the below error when trying to import:
OLE DB or ODBC error: Accessor is not a parameter accessor..
Out of line object Datasource referring to id ….
Out of line object datasourceview … temp_dsv
Here is the image:
None of this error made any sense. It was just a table in Oracle we were trying to pull from. After some troubleshooting I was able to find that a date column was causing the issue. Upon further digging we found that it was dates that had the year set to ‘0001’.
So you will need to use a query to convert these bad dates to a valid year, like 1900 or something similar when pulling data from Oracle with PowerPivot.