BradEdwards
Technical User
I want to write an SQL Pass Through query that takes records from an Access database and inserts them into my SQL Database. I know I can write an Append query or do a db.execute ("Insert...."
, but from what I've read, the only way I can use qdf.execute dbRunAsync is if I'm using and ODBC connection rather than MS Jet Engine. I want to use dbRunAsync so I can do other things while the SQL Pass Through query is still running because it takes about 4 minutes for my query to run. Is there anyway I can reference an Access table inside of an SQL Pass Through Query. Or is there another way that I'm not aware of that I can continue to run my code while the query is running. Thanks.
, but from what I've read, the only way I can use qdf.execute dbRunAsync is if I'm using and ODBC connection rather than MS Jet Engine. I want to use dbRunAsync so I can do other things while the SQL Pass Through query is still running because it takes about 4 minutes for my query to run. Is there anyway I can reference an Access table inside of an SQL Pass Through Query. Or is there another way that I'm not aware of that I can continue to run my code while the query is running. Thanks.
