ADO Data Type Mismatch error

  • Thread starter Thread starter Lucky
  • Start date Start date
L

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
 
What's the exact code for

strSQL = "INSERT INTO .

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