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.


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele


"Lucky" <(E-Mail Removed)> wrote in message
news:01a001c3627a$7f8e24e0$(E-Mail Removed)...
> 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
>