Data Type Mismatch error during DAO to ADO Conversion

[Lucky]

I need to convert DAO QueryDef to ADO. I have been able
to convert the majority of them except for one where the
original data source is Pass-Through query (via ODBC from
Oracle db). When this update is run in DAO, it performs
flawlessly. However, in ADO I get the following error
message: "Data Type Mismatch in Criteria Expression").

I use the following code:

Set cnn = CurrentProject.Connection

'SQL statement
strSQL = "NSERT INTO tbl ." & _
"SELECT qry ." & _
"FROM qry ." & _
"WHERE .;"

'Append data to table
cnn.Execute strSQL

Set cnn = Nothing

When I use Select query with the same exact data (and not
Pass-Through query) this update runs great. Any idea what
I need to do to get this update running with ADO?

Thank you for any suggestions.

Lucky