@confidential: "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"
    @djsteele: "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
<url>
news:01a001c3627a$7f8e24e0$<email_address>
<quote>"
{'source': 'USENET', 'other_information': '{"reply_count": 1, "forum_name": "microsoft.public.access.modulesdaovba.20140618.mbox"}', 'file': 'data/output/usenet-microsoft.public.parquet'}