Unknown error occurred when converting data types

[mfarr76]

Hello all,

Has anyone experienced the following error message when they import from a query in 2010 Access into Power Pivot, "An unknown error occurred when converting to the data type table 'XXXX' column 'XXX'."

The X are the table and column name within the query that I built in Access. It is a simple expression that is show below. Any suggestions?



F&D ($/BOE): IIf([C1316]>0,[C1316]/([C815]+[C819]+[C816]/6),Null)

Thanks in advanced!

 

[mole999]

text being used as a number or similar issue