ADO Data Type Mismatch error

[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). 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

'Get SQL
strSQL = "INSERT INTO .

'Append data to table
cnn.Execute strSQL

Set cnn = Nothing

Any idea where I am going wrong?

Thank you for your help.

Lucky

 

[Douglas J. Steele]

What's the exact code for

strSQL = "INSERT INTO .

It's possible there's something wrong with your SQL statement.